dbconnect case insensitive query

[rdownie]

Using the dbconnect app without using advance(query), is there a way to make your lookup case insensitive by adding case_sensitive_match = false to the transforms.conf like you do with a standard lookup? It doesn't appear to work, possibly an enhancement?
Thanks,
-Bob

[ziegfried]

It's currently not possible to enforce case-insensitive lookups when the simple mode is used (where only the table name is specified). It's possible when specifying a custom SQL query for the lookup, though:

SELECT field1, field2 FROM mytable WHERE LOWER(somekey) = LOWER($somekey$)

(The actual SQL query may vary depending on the kind of database server you're using)