CLR custom aggregations in SQL help in executing complex calculations efficiently, overcoming standard SQL limitations.
Though limitations exist, such as the inability to use ORDER BY with custom aggregates, workarounds like using derived tables or CTEs can be implemented.