Deleting rows from tables is straight forward:
db(delete_from(tab).where(tab.alpha == 35));The where clause specifies which rows should be affected.
where can be called with a dynamic argument. In case the
dynamic condition is false, no WHERE will be included in the serialized
statement.
If you want to delete all rows from a table, the truncate function might be the faster option.
db(truncate(tab));Some backends support where conditions that use additional tables. These are
supplied to the statement via the using clause.
db(delete_from(foo).using_(bar).where(
foo.bar_id == bar.id
and bar.username == "johndoe"
));