Somewhere someone started the tradition of capitalizing keywords in SQL. Its like shouting all the unimportant parts of the code and making what’s important harder to read.
SELECT b.id as book_id, a.name as author, b.pub_date as publication_date FORM books b LEFT JOIN authors a on b.id = a.book_id WHERE foo_bar = 'Fibonacci';
I say stop doing that. And use instead super indentation and formatting. Pseudo English is easier to read when it is not capitalized.
select b.id as book_id, a.name as author, b.pub_date as publication_date from books left join authors a on b.id = a.book_id where foo_bar = 'Fibonacci'