According to the H3 docs, looks like custom sql (i.e. <sql-insert>, <sql-delete>, etc.) does not support named parameters?

Is this something that is on the roadmap, or is it implemented and just not yet documented?

I have a case where I need to only override the <sql-delete>... we are using an effective date record pattern and I want to essentially expire the record.... so do an update in the overridden <sql-delete>... sounds odd, however that is the case.

When I override the sql-delete with an update (to set the effective end date to now, as well as set the userid that did this logical delete)...

Basically it isnt binding the params properly because they are positional
(?,?,?)


What is happening is that the ID and VERSION parameters are being bound, however not the user_oid...

Anyway, my assumption is that a named parameter (i.e. :user_oid ) would get around the positional issue.

Otherwise if someone has a good idea how to do a <sql-delete> with an update....

Also, if the named parameters for custom sql is on the roadmap or needs someone to do it.. let me know... I could contrib..

Cheers

use Stored procedures, in the code of stored proc, make the correct job.