Hints for the SQL inspector

Hello Community

I recently discovered the SQL inspector/assistant and I love it. However, the way I'm using SQL prevent it from actually working (thus my discovery being recent...)

When I write a SQL snippet, it's either a portion (no 'FROM' clause) or it's refering to a table using a generic prefix; the prefix will be substituted at runtime depending on the user's choice.

For example:

SELECT field1, field FROM _prefix_table_name

Of course the inspector has no way to know if field1 and field2 are valid. Is there a way to "give hints" to the inspector to point it to the actual table?

TIA

greg

Please sign in to leave a comment.