textSQL
textSQL copied to clipboard
[BYOD] support for different SQL dialects (MySQL)
Currently, the SQL statements for setting up table and enum metadata, for the language model, are written in PostgreSQL. We want to add support for MySQL as well.
The functions we currently use to generate metadata live in byod/api/app/setup/utils.py
.
They are named
-
get_type_names()
-
get_table_names()
-
generate_table_metadata()
-
generate_type_metadata()
This was my attempt at generating table and enum metadata. It may be a little hacky. Feel free to give it your best shot.
[BYOD] support for different SQL dialects (ORACLE)