Fun with SQL: Recursive CTEs in PostgresCommon Table Expressions (CTEs) are a powerful construct within SQL. In day to day conversation, you may hear CTEs referred to as WITH clauses. You can think of CTEs as similar to a view that is materialized only while that query is running and does not exist outside of that query. CTEs can be very useful building blocks for allowing your large SQL queries to be more readable. But, they can also b
SQLアンチパターンon Rails Ⅰ部（論理設計） - Qiita
