database prefix variable and autocomplete/sql checking

I'm writing code based on an available script which uses a variable to set the prefix for the table.

So a query (mysql) might look like "SELECT * FROM {$prefix}members..."

Unsurprisingly, I get no useful autocomplete or column name checking, the IDE shows all columns as invalid.

Has anyone discovered a way to include a variable or define in the table name as prefixing tables is a common practice in re-usable scripts?