psql compatible embedded database

[v217]

I've read that https://duckdb.org/ uses the same parser as psql.
I don't know about embedded MonetDB/e.
So for newcomers an embedded database is far easier to get started with than postgresql.
This might be a temporary solution till sqlite is fully supported.
Thanks!

[EvgSkv]

Thanks for pointing this out!
It appears there are some differences in DuckDB and PostgreSQL syntax, as query

SELECT x FROM UNNEST([1,2,3]) AS x

gave me a syntax error related to array notation in DuckDB. I would like to look at it more carefully though.

[v217]

Thank you, I confounded 'same parser' with 'same functionality'.
Monetdb supports the UNNEST command, but I don't know enough SQL to run the examples. There are lots of differences eg. <> instead of !=, etc ...

[EvgSkv]

Core of Logica functionality now works on SQLite, which requires no setup.

[v217]

That's absolutely great news! I think a lot of people will be happy about this!