Draft: feat(sql): Update delete in DAO to use SQL for bulk deletion

• feat(sql): Update delete in DAO to use SQL for bulk deletion

Previously we loaded in and deleted all records that matched a given query. This created unnecessary load and lag on large delete requests, which would be a blocker to larger maintenance operations.

In testing, Hibernate does not support joins in HQL delete statements. While we could switch to native SQL, this runs the risk of not playing well with our previous query generation which is meant to support HQL. To circumevent this, any query that makes use of explicit joins in the query will error out.

• chore: Start 1.4.1 SNAPSHOT release