Runtime valuableWhen you execute the method, your programs have to input data into the method by argument. (Data is for example, id, name, or numbers in the gWHEREh condition)
For example, you designed following SQL
SELECT * FROM TOY WHERE ID = e$IDf$ID is a valuable you want to input on executing the method.
The term starting with e$f is the valuable and it is replaced automatically on executing the method
You can use the Runtime Valuables in any field of SQL.
SubqueryYou can call other method executing SELECT SQL as sub query.
For example, you design following SQL
UPDATE CHILDREN SET ID = (@selectMax) + 1eselectMaxf is a method name executing SELECT SQL. The term starting with e@f means sub query. If selectMax means SQL below
SELECT MAX(CHILDREN.ID) FROM CHILDRENThe first SQL will be transformed like below
UPDATE CHILDREN SET ID = (SELECT MAX(CHILDREN.ID) FROM CHILDREN) + 1
adjustment on executing the method