Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

Describe your question Hope that same question does not appear in issues already but I can not find it. I am using SQLAlchemy in a package where I want to offer user to write its own SQL query. For ...