Try using Text mode when writing your code, or if you're using Formula mode, make sure to wrap any text values in single (') or double (") quotes and use the + operator to concatenate.
Example for Formula mode:
"Select " + <columnname datapill> + " from " + <tablename datapill>;
This ensures that static strings and datapills are combined correctly in the expression.
