You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi, I'm experimenting with Text-to-SQL on an existing PostgreSQL database. The table names in this database have been CaPiTaLized, unfortunately, and unquoted tables names in queries are lowercased.
I am able to generate working SQL by adding some context to the tables like this:
I feel like I'm abuse the table context, and this would be better pulled up. Would it make sense to add "Always quote tables names." to DEFAULT_TEXT_TO_SQL_TMPL?
Edit: This also applies to field names. I found this does not always lead to names being quoted. It's a bit hit and miss.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hi, I'm experimenting with Text-to-SQL on an existing PostgreSQL database. The table names in this database have been CaPiTaLized, unfortunately, and unquoted tables names in queries are lowercased.
I am able to generate working SQL by adding some context to the tables like this:
I feel like I'm abuse the table context, and this would be better pulled up. Would it make sense to add "Always quote tables names." to
DEFAULT_TEXT_TO_SQL_TMPL
?Edit: This also applies to field names. I found this does not always lead to names being quoted. It's a bit hit and miss.
Beta Was this translation helpful? Give feedback.
All reactions