Using LATERAL or APPLY to create local variables in SQL is great alternative to the WITH clause