search

Canner / WrenAI

🚀 Open-source SQL AI Agent for Text-to-SQL. Make Text2SQL Easy! 🙌
https://getwren.ai/oss
GNU Affero General Public License v3.0
1.76k stars 162 forks source link

Feature: OracleDB Support #236

Open Ethan-Otto opened 4 months ago

Ethan-Otto commented 4 months ago

I work at a company with many oracle databases. So oracle compatability or a template for how we can set it up ourselves would be great.

wwwy3y3 commented 4 months ago

Hi @Ethan-Otto , thanks for this feature request.

In order to support database faster, we're actually working on using the ibis-project to connect to the datasource. The concept is that WrenAI generates ibis-executable SQL, which is then transformed to the specific datasource using the appropriate dialect. You can see how we invoke the ibis-project in the Wren Engine repo branch. It's still a work in progress.

Once we finish refactoring to ibis, we'll see if we put Oracle into our next roadmap.

wwwy3y3 commented 4 months ago

Hi all, upvote here https://github.com/Canner/WrenAI/discussions/327#discussioncomment-9578178 if you think Oracle is important to you as well.

luca-iannelli commented 1 month ago

Please implement oracle support! I work for an italian university and in Italy almost all universities use oracle for their informaton systems. It would be great to have this tool available to all the academic community. Thaks a lot.