[mo_42]

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?

[jessekv]

Not sure I understand, but SQLite itself sort of does that. You can take a look at the architecture here: https://www.sqlite.org/arch.html