[xtacy]

This documentation page is an excellent overview for anyone who wishes to understand how a declarative language such as SQL is actually translated to an execution plan behind the scenes:

https://github.com/google/lovefield/blob/master/docs/dd/05_q...