Feature request: Add refresh token fields to Shopify Drizzle session storage #2996
Description
Overview/summary
Hi team — I’m using @shopify/shopify-app-session-storage-drizzle for session persistence.
Compared to other session storage adapters, the Drizzle storage schema does not include columns/fields for refresh-token related data (e.g., refresh token, expiry, or token rotation metadata). This makes it difficult to implement long-lived sessions / token rotation workflows consistently across adapters.
Expected behavior
Provide refresh-token related fields in the Drizzle session storage schema, similar to other official session storage packages, so apps can persist and rotate tokens without custom out-of-band storage.
Current behavior
The Drizzle session storage table definition only includes the basic session fields (shop, state, scope, access token, etc.), but there is no dedicated place to persist refresh token info. Developers must fork the adapter or store refresh token data elsewhere, which breaks adapter parity.