manticore-projects

> Thanks for the speed feedback! > > > H2 Git Snapshot > > Can I pull this from a Maven repo somewhere? Unfortunately not, only Git Sources. Sorry. >...

Greetings again! This `MERGE` should/does work on H2/Postgres/Oracle. There should not be any difference when you use Postgres > 15.0

```sql MERGE INTO delivery USING ( SELECT id FROM notification WHERE expiration_time < localtimestamp ) n ON (notification_id = n.id ) WHEN MATCHED THEN UPDATE SET send_state = 'EXPIRED' WHERE...

One more thing: Can you/do you want to try calling this in a loop and partition the updates: ```sql update delivery_test set send_state='EXPIRED' where send_state 'EXPIRED' and notification_id in( select...

> It this particular case this additional condition can be appended to the `ON` clause, because there are no other `WHEN` clauses, unless some DBMS has limitations in that area....

@marcelstoer: If you need to support multiple Databases, then the last option I have for you was `JSQLParser` which can parse your `MERGE` template statement and then rewrite it in...

Greetings. for named parameters, "=>" is pretty much the established and accepted standard and JSQLParser supports this and Postgres does too. If you are interested in supporting this legacy Postgres...

Greetings, the `ALTER` statements are lacking many RDBMS specific features and need a more or less complete rewrite. I myself have very limited interest in DDL statements and so you...