Add Oracle Database core dialect.

[igalklebanov]

Hey 👋

Knex supports OracleDB with a core dialect. As part of becoming THE "drop-in" replacement for Knex, we should look for the easy wins in getting as close as reasonable to feature parity. This seems like one.

oracledb (or node-oracledb) has roughly 200k downloads per week, and there's an increase over time:

https://npmtrends.com/oracledb

If you want to use Kysely with Oracle DB, please drop a comment OR reaction to this issue. Help us understand the demand in the typescript community for this.

[hinogi]

Oracle also offers docker container for easy testing and with node-oracle 6 also easier setup since you don't need a fat client also but can use a nodejs only implementation as well.

[ikdi]

It would be great to have Oracle DB support

[igalklebanov]

More numbers for prioritization.

Just a hint at oracledb usage with Typescript.

[bslinkrga]

As unfortunate as it is, some of us are having to work with Oracle whether we'd like to or not, until we can migrate off of it fully I'd like to have our integration be the "least crappy" possible, I love Kysley on some of my other projects and it'd be pretty awesome to have that type safety and beautiful DevX even when being stuck with the legacy db systems. For now I guess we'll have to use knex and do a lot of type casting haha