fsprojects / Rezoom.SQL

Statically typechecks a common SQL dialect and translates it to various RDBMS backends
MIT License
669 stars 25 forks source link

Create / Drop Schema support #52

Open smoothdeveloper opened 5 years ago

smoothdeveloper commented 5 years ago

@rspeele would you mind giving a look at https://github.com/smoothdeveloper/Rezoom.SQL/pull/1

I've implemented basic stuff to get create schema and drop schema parsing and translation.

I'm wondering if there is support in the library to explicitly avoid such feature with specific backends? SQLite won't support the generated statements.

rspeele commented 4 years ago

Regarding avoiding specific backends, normally this is handled by failing during the backend translation stage. Like SQLite ALTER TABLE