How to create a prisma model from a SQL view

Question

Is it possible to have 'prisma introspect' create models for views in Postgres ?

Answer 1

Currently not, but we have a request for that here that you can follow for more updates. As a workaround, you can manually add that view to schema.prisma as a model and then query as you do for normal models.