it would be very nice @sean! right now im struggling between using jdbc/insert! and not being able to pass NOW() as a parameter (am I really unable to do so?) or using insert-into and not being able to retrieve ids

If your application and database are in the same time zone you could pass (java.util.Date.) and use jdbc/insert!.

I myself am strongly of the opinion that the database should be the sole source of instantaneous time for database records 😛 but I get caremad about a good number of things that have only trivial impact for most cases

Yes, definitely. I would prefer not seeing code that tries to insert some application-specific variant of now() into the DB... but... 🙂

It seems frequent enough that maybe some special value in an insert! should trigger that perhaps?