Use a Query Object if you have an urge for SQL in Business Central

The Query Object is often overlooked in Business Central, but it does give SQL’ish access to creating queries, check it out: