[Feature Request]: Use prepared statements on Drizzle adapter

[crisog]

Package

​@lucia-auth/session-drizzle

Description

Using prepared statements is significantly faster. For some of us that are using auth middleware, these queries are executed quite often resulting in a penalty in performance. More info about prepared statements can be found here.

[A1X5H04]

@crisog Can I know how are you using middleware with lucia, or sharing the repo will also help me 🙏🙏