search

jklukas / sqlalchemy-views

Add CreateView and DropView to SQLAlchemy
Other
57 stars 14 forks source link

Materialized view support #12

Open taebow opened 4 years ago

taebow commented 4 years ago

If there aren't impediments, I would like to add an option to the CreateView method to create materialized view.

jklukas commented 4 years ago

My general impression is that materialized views are a fairly implementation-specific concept with significantly different syntax per db. It may be more reasonable for individual dialects to implement appropriate constructs for materialized views.

sqlalchemy-redshift, for example, recently added support within the dialect for creating materialized views: https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/202