But then i will not be SQL. SQL is built like this because all these operations are projections on a set. You can not really change their order and have meaning

But then i will not be SQL. SQL is built like this because all these operations are projections on a set. You can not really change their order and have meaningful results. Some oeprators can be swapped, but this part of the optimization process and nothing you need to be aware of.