The biggest painpoints IMO involve: * anything with data that doesn't fit in memory * anything that could trivially be written in an SQL window function * an

The biggest painpoints IMO involve: * anything with data that doesn't fit in memory * anything that could trivially be written in an SQL window function * anything involving table joins, especially multi-column and/or non-inner joins. * anything involving subtotal-like summaries (easily implemented using GROUPING SETS, CUBE, and/or ROLLUP)