add _timezone DSN query parameter

_timezone accepts an IANA timezone name, such as "UTC", and applies it to both reads and writes.

For writes, time.Time values are converted to the target timezone before formatting.

For reads, timezone-less strings are interpreted as being in the target timezone.

Supporting configuration at the DB driver level helps avoid industrial accidents when working with SQLite datetime strings, which lack time zones.

Merge request reports

Loading