Is there a way to define the default data source and schema for SQL injection?
I have several database sources configured in the Database window (they are all MySQL sources, I can see all tables from the Database window, and I can execute scripts against them)
If I create a JDBC string with a select statement, and then inject MySQL language into it(Alt + Enter > Inject Language or Reference > MySQL), the string automatically auto highlights recognising the select/from/where keywords.
However, it does not recognize the table or column names, so auto-complete does not work.
String sql = "select * from account where name=?"
However, if I enter the schema before the table name, then it works:
String sql = "select * from dev_db.account where name=?"
I would expect to be able to setup somewhere at project level the default source and schema for SQL injection, but I cannot find where.