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.
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?