The database connectors we support right now are: - MySQL - Postgres - Snowflake - Apache Impala
In terms of how we map English queries to SQL, we only look at the schema at the moment.
We have the ability, and have experimented with adding enriching information such as sampling the data, as well adding comments to the schemas.
We've noticed that both approaches actually do increase accuracy but just to keep things simple for the initial release we haven't added those yet.
Just so I know for future reference, what system do you use for DB object comments?
Thanks again for your feedback!
Postgres supports this natively (there was actually an earlier HN post today about "little known Postgres features" that mentioned it): https://www.postgresql.org/docs/current/sql-comment.html
We use it extensively because tools like Datagrip will display these comments in the schema browser. It would be pretty trivial I imagine to update your tool to pull these comments from the Postgres schema.
"Lesser Known Postgres Features (2021)":
https://news.ycombinator.com/item?id=37309309
The database connectors we support right now are: - MySQL - Postgres - Snowflake - Apache Impala
In terms of how we map English queries to SQL, we only look at the schema at the moment.
We have the ability, and have experimented with adding enriching information such as sampling the data, as well adding comments to the schemas.
We've noticed that both approaches actually do increase accuracy but just to keep things simple for the initial release we haven't added those yet.
Just so I know for future reference, what system do you use for DB object comments?
Thanks again for your feedback!