Í‘m not happy with SQL for querying data. Especially joins, windowing, subqueries and CTEs are often quite clunky. Especially CTEs are often not doing what you

Í‘m not happy with SQL for querying data. Especially joins, windowing, subqueries and CTEs are often quite clunky. Especially CTEs are often not doing what you intend (full table scans, poor performance). SQL is a great standard, because you can use it everywhere, but it’s not perfect for everything. You can feel, that it comes from ancient times.