Comment by bandushrew

You can use stored procs and/or views to hide the details of queries if you want.

the specifics of an inner join vs outer join vs left join etc are crucial though. It makes sense to be able to specify them.