Does it support Updates, Deletes?

[mercurial-moon]

I see that Preql seems to be heavily geared towards SELECT statements, do you plan to support UPDATE, DELETE etc. i.e the CUD parts of CRUD?

[erezsh]

It actually does support basic CRUD operations. See here for example: https://github.com/erezsh/reladiff/blob/master/dev/prepare_db.pql

Right now Preql isn't under active development. I have some ideas of making a new version in the future, but no definite plans.

[mercurial-moon]

@erezsh ok thanks for the update! I was trying to compare Preql with PRQL, i think PRQL only does selects... is Preql usable in its current state?

[erezsh]

Yes, for simple operations it's definitely usable. And if you run into any bugs, I'll do my best to fix them.

But keep in mind you'll probably run into small bumps in the road, especially if you try fancy stuff.

[mercurial-moon]

@erezsh Ok thanks... and in case we need to call functions (internal or user defined) in postgres will Preql pass them to the underlying DB?

[erezsh]

Yes, it should work using the SQL() escape hatch. See here: https://preql.readthedocs.io/en/latest/tutorial.html#the-sql-escape-hatch