Support for USING Keyword in DELETE Queries

[tycyssg]

Description:

I am currently using the latest version of pg-mem (2.8.1) primarily for testing purposes. I have several DELETE queries that utilize the USING keyword to delete rows based on data from a different table. However, it appears that pg-mem does not currently support the USING keyword in DELETE statements.

Current Workaround:

At present, to conduct tests using pg-mem, I have had to re-write the queries using subqueries instead of the USING clause. While this approach is functional, it results in less readable and potentially less efficient SQL statements.

Request:

Kindly request the implementation of support for the USING keyword in DELETE statements within pg-mem. This would greatly enhance the usability and fidelity of pg-mem for testing purposes, aligning it more closely with PostgreSQL's capabilities.