Dependencies issue with DROP command for views and materialized views

[kraftaa]

Current Behavior:

If I run cargo run build on my views/materialized views models I'm getting errors about dependent views . I either need to delete all view with CASCADE or don't use views in other views.

Expected Behavior:

I expect it to be updated without deleting all views. I suppose it could be done via

• no DROP command for views and materialized views, only for the tables.
• views: CREATE or REPLACE VIEW command
• materialized views: REFRESH MATERIALIZED VIEW if exists, otherwise CREATE MATERIALIZED VIEW.

I've submitted a PR with my solution.

thank you