v1 Roadmap

Drizzle Kit V1

• generated columns support [beta branch]
• Brocli integration to Drizzle Kit
• Generated SQL migration strict mode without try catches and if not exists
• Drizzle Kit goes OSS steam 🎉
• PostgreSQL enums alternations improvements
• PostgreSQL RLS support
• check constraint support in Drizzle Kit
• Exposed API for programmatic access in Drizzle Kit
• materialized views support in Drizzle Kit
• Drizzle Studio mkcert fixes for dockerised environments

Drizzle ORM V1

• Migrate to folder v3, remove journal
• Add explain mode for push
• Add commutative migrations check
• generated columns support [beta branch]
• MySQL .$returningIds()
• mode: number and mode: bigint support for PostgreSQL decimals
• Table declarations with (t) => callback to optionally omit column type imports
• Optional database aliases for columns in table declarations -> id: serial()
• PostgreSQL RLS support
• Relational Queries V2 API
• drizzle('pg', ...) driver instantiation to lower the entrance learning curve
• CockroachDB support (supported with strict SQL migrations)
• Native seeding
• fixes: #2575, #2572, #2571, #2568, #2559, #2555, #2530, #2514, #2510, #2506, #2496, #2486, #2484, #2474, #2472, #2458, #2455, add drizzle-kit migrate/push --inspect #2488, #2432, #2430, #2426, #2424, #2418, #2414, #2401, #2396, #2395, #2394, #2390, #2389, #2388, #2387, #2384, #1210, #1157, #1113, #1020, #1003, #998, #830, #724, #2254, #2239, #2236, #2224, #2216, #2198, #2189, #2183, #2174, #2169, #2157, #2151, #2146, #2136, #2122, #2085, #2067, #2047, #2015, #1928, #1835, #1804, #1765, #1748, #1744, #1625, #1428, #1402, #1315, #1313, #1294, #1272, #1269, #1225, #2378, #2343, #2322, #2315, #2282, #2279
• MSSQL support
• 🎉 V1 RELEASE STREAM 🎉
• Down migrations, better rollbacks and improvements to migrate experience in Drizzle Kit
• NODE_ENV support for embedded .env consumer
• MariaDB support