Views: How do you create them? What is "work in progress" versus what works now?

[sp88011]

https://orm.drizzle.team/docs/views

The docs about Views say:

Views are currently only implemented in the drizzle-orm, drizzle-kit does not support views yet. You can query the views that already exist in the database, but they won’t be added to drizzle-kit migrations or db push as of now.

Am I understanding this right: As of now, I can declare a view using Drizzle, but that will not actually create the view in my database I will have to create the actual view directly at the database level?

I tried declaring a view and I'm getting a "relation not found" error when I try to select from it.

So the docs about Declaring views are not relevant, really only Declaring existing views is relevant at this point?

[hisbaan]

As a workaround to views not yet being supported in drizzle-kit, my team currently defines the views in our schema.ts and then generates a custom migration for views with npx drizzle-kit generate --custom then we fill it with a CREATE VIEW ... statement. It's not the prettiest solution, but it works