This example invokes the SQL UDF value_expression in the select list of the derived table dt.
SELECT * FROM (SELECT a1, test.value_expression(3,4), c1 FROM t1 WHERE a1>b1) AS dt (a,b,c);
This example invokes the SQL UDF value_expression in the WHERE clause of the derived table dt.
SELECT * FROM (SELECT a1, b1, c1 FROM t1 WHERE test.value_expression(b1,c1)>10) AS dt (a,b,c);