search

bitemyapp / esqueleto

New home of Esqueleto, please file issues so we can get things caught up!
BSD 3-Clause "New" or "Revised" License
376 stars 108 forks source link

`update` doesn't work with Experimental syntax #251

Open parsonsmatt opened 3 years ago

parsonsmatt commented 3 years ago

update does not work with the new Experimental syntax, even though it probably should!

Unfortunately, support for fancier updates differs across backends. MySQL and Postgresql differ, and SQLite appears to mirror Postgres.

As an example, MySQL allows you to specify updates on a bunch of tables in the FROM clause, while the other two engines require a single table to be updated (but other tables can be mentioned in the FROM for filtering).

belevy commented 3 years ago

This is something I was playing around with at the end of last year. It honestly is probably best to just only support ANSI SQL updates in the main module and all the individual modules can support their own version of update that allows JOINs