Feat Request: Oracle Driver support

[sull1vxn]

Use Case

Would be nice to have Oracle support for this plugin. Plenty of legacy companies - including mine - use Oracle and could benefit from this.

I began building it out in a separate plugin myself, however, I noticed my logic was becoming more or less a copy of the SQL output plugin! I am more than happy to implement the support myself, I just wanted to confirm you are okay with this functionality being added before moving on with it.

Expected behavior

• Creates valid Oracle connection string
• Builds TableExists and TableListColumns templates in an Oracle dialect (would just be an if statement similar to the if driver == 'sqlite' in the Init())
• Creates placeholders that align properly with Oracle syntax
• all integrated into the SQL output plugin

Actual behavior

No Oracle option exists yet nor have I implemented it myself. Users currently have to build it custom if they want Oracle integration. Open sourcing Oracle integration would allow a shared Oracle option, bringing about all the benefits that come with open source.

Additional info

No response

[srebhan]

Next steps: Someone needs to implement this in the outputs.sql plugin using the go-ora library.