chaisql / chai

Modern embedded SQL database
MIT License
1.56k stars 95 forks source link

Didn't find it in the docs: approx. level of SQL compatibility? #517

Closed metaleap closed 11 months ago

metaleap commented 1 year ago

I mean, between Postgres and MariaDB and Oracle and SQL Server there can be wild SQL syntax / expression variations for various constructs. I'm curious what this project is shooting for basically.

In other words: "will an ORM supporting PostgreSQL likely overwhelmingly work well, excepting (list of non-supported things here... eg. on-update triggers?) — or does it also need to have an SQL-generator for eg. SQLite too?" What's your "SQL basis"?

Let's assume we're talking not just CRUD but also create table, create index (if even applicable?)

Thanks already, really eyeing a giving this a spin instead of CGO SQLite!