Goland is great at auto-completing SQL statements if I use the sql.DB package functions.
For example, Goland will provide SQL autocompletion (including DDL data) in this setting:
result, err := someDB.Exec(`INSERT INTO <cursor here>`)
Can I configure Goland to show me SQL autocompletion in other contexts? For instance, I'm using github.com/jmoiron/sqlx and it has functions of the form:
err := someDB.Get(&user, `SELECT * FROM users WHERE email="%s"`, email)
In this second example, autocompletion wasn't triggered.
I can't find where/if this is configured in the Goland settings. Can I tell Goland which function parameters should be eligible for SQL autocompletion?
You can use Alt + Enter inside the query and then use Inject Language and start typing the SQL dialect that you want to insert.