SQL SELECT constructed from inputs.
TableName | Name of table to do select on. |
TargetList | List of targets to select. |
WhereDict | Column name / value pairs. |
Note that for the dicts, you (currently) must put quotes around any values that will go into text columns or receive an error. We may add support in a future release for automatically detecting the column type and quoting values as necessary.
For information regarding exceptions / errors, see
here.
% SqlSelectStatement my_table {notes} {desc 'first'}
SELECT notes FROM my_table WHERE desc = 'first'