Invalid date/time conversions when using SxQL

[michj]

When using SxQL with date style fields, SxQL seems to create a STRING representation of the date whilst cl-duckdb requires a local-time version.

This stops the use of SxQL for any schema with dates in it.

[ak-coram]

@michj thanks for reporting this! I'm not sure I understand: SxQL generates SQL strings and shouldn't have anything to do with how query parameters are bound or query results are returned. In either case, if you need to work with strings instead of date / datetime values, you can simply cast them to text in your query:

(ddb:q (yield (select ((:as (:cast (:as (:now) :text)) :x)))))
;; => (("x" . #("2025-06-23 05:29:20.734+02")))

Could you perhaps provide an example to reproduce this?