Interesting approach. But for me the main disadvantage of SQL code embedded in other language is lack of syntax highlighting/checking.

I've had the best experience with embrace-sql which translates sql-files with magic comment-delimited parametrized queries to python-callable modules: https://pypi.org/project/embrace/