Delete​

delete – remove objects from a database.

[ with with-item [, ...] ]

delete expr

[ filter filter-expr ]

[ order by order-expr [direction] [then ...] ]

[ offset offset-expr ]

[ limit  limit-expr ] ;

with

Alias declarations.

The with clause allows specifying module aliases as well as expression aliases that can be referenced by the delete statement. See With block for more information.

delete ...

The entire delete ... statement is syntactic sugar for delete (select ...). Therefore, the base expr and the following filter, order by, offset, and limit clauses shape the set to be deleted the same way an explicit select would.

with module example
delete User
filter User.name = 'Alice Smith';

with module example
delete (select User
        filter User.name = 'Alice Smith');