It still needs a bit of work, but I wrote a small library for Python to use SQL in the Yesql style: https://github.com/KMahoney/pyesql
There is an another (slightly older) Clojure library - https://github.com/ray1729/sql-phrasebook
This was based on the venerable Perl CPAN module - https://metacpan.org/pod/Data::Phrasebook::SQL
Also an interesting read - http://www.perl.com/pub/2002/10/22/phrasebook.html | http://ootips.org/yonat/patterns/phrasebook.html