I came across this blog as well because I got interested in writing a compiler that converts SQL into source code of a type-checked language.

Are there any blog series about the details of query planning, optimization etc?