marcominerva / DatabaseGPT

Query a database using natural language
https://databasegpt.azurewebsites.net/
MIT License
67 stars 15 forks source link

Optmize check for excluded tables in SQL Server Provider #72

Open marcominerva opened 1 month ago

marcominerva commented 1 month ago

The code in SQL Server Provider that checks for excluded columns is "cumbersome":

https://github.com/marcominerva/DatabaseGPT/blob/ba9468bceaa19b6f4668ffe02e40d50c731cb80b/src/DatabaseGpt.SqlServer/SqlServerDatabaseGptProvider.cs#L79-L109

On the other hand, the Postgres Provider uses a more compact solution.

We should verify whether we can follow a similar approach also for SQL Server.