[Feature Request]: Support timestamp mode for Drizzle SQLite expiry column

[LinusOP]

Package

​@lucia-auth/session-drizzle

Description

It is quite common to want to use the timestamp mode for an integer column containing a timestamp/date when using Drizzle for SQLite. This means Drizzle will convert to and from Date in that column automatically.

Currently the Drizzle adapter does a integer > Date conversion and so it expects a number returned from Drizzle, thus it does not support this mode.

Adding support for this mode is of course not necessary but means people can keep their schemas uniform and can use the mode for all columns, should they prefer it.