[crateless]

Are there any resources e.g books, blogs etc. that have a low-level description of the data structures/algos involved when SQL queries are run?

[defaultcompany]

You might look at SQLToy which is a DB and blog I wrote to teach how SQL processing works internally: https://github.com/weinberg/SQLToy