The Art of SQL is a book that I've picked up recently. It seems to be a very good book on theoretical SQL. I'll write a review as soon as I'm finished.
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.