Best to avoid custom SQL if possible as it can cause performance problems. Better to build views in your own SQL database and connect to these as multiple tables. Make sure you include common ID fields in each view so you can join on these in Tables dialog in Tableau. This is what we are using in practice with an Oracle database.
Excellent! Many thanks, Eric! Views are completelly gone from my head while struggling with Data Blending! Thanks again!