What's your favorite construct in SQL?

megaman1970@beehaw.org to Programming@beehaw.org – 5 points –

For me, it's CTE's. I find it amazing to complete a calculation with clear intermediate steps, and goes a long way towards convincing people to use SQL rather than Excel to perform calculations on large tables of data.

What construct do you like using on a daily basis?

5

Only thing cooler than CTEs are Recursive CTEs, but I struggle to find use cases where I can sneak one in.

I believe recursive CTEs are pretty cool for tree traversal. Anytime you've got a table with a foreign key on its own primary key they might come in handy.

CTEs are so helpful for me. They make complex queries much easier to construct and lets me ‘unit test’ the parts I’m working on.

Same here, CTEs were a game changer for me when I learned about them