Sure, while views may be fine for small projects, using them for larger projects like data warehousing is usually a mistake you'll come to regret. SQL views ar

Sure, while views may be fine for small projects, using them for larger projects like data warehousing is usually a mistake you'll come to regret. SQL views are rarely unit tested so you always end up in a regression nightmare when you need to make updates. If you're going to go pure SQL, you should use something like dbt.