queryAvailable

Returns the result set accessible by a given child.

The result set are any rows that have already been selected and the operation is running on. For example:

CREATE TRIGGER some_trigger BEFORE INSERT OF some_table BEGIN; SELECT * FROM some_table WHERE new._id = some_table._id; END;

In this situation, everything between BEGIN and END has access to the "new" row, which is its own result set with columns. However, "new" is not a table that can be selected from:

CREATE TRIGGER some_trigger BEFORE INSERT OF some_table BEGIN; SELECT * FROM new -- invalid WHERE new._id = some_table._id; END;