Before and after: Constraints

June 22, 2025 ยท View on GitHub

< Differences

Before and after: Constraints

Clauses

sqlpp11sqlpp23

Unconditional select, update, and delete

select(tab.id).from(tab).unconditionally();
select(tab.id).from(tab);
update(tab)
    .set(tab.version = 11)
    .unconditionally();
update(tab).set(tab.version = 11);
remove_from(tab).unconditionally();
delete_from(tab); // works
truncate(tab); // preferred

Joins

sqlpp11sqlpp23

Inner Joins

foo.join(bar).unconditionally();
foo.inner_join(bar).unconditionally();
// or
foo.cross_join(bar);
foo.cross_join(bar);

Outer Joins

foo.left_outer_join(bar).unconditionally();
foo.right_outer_join(bar).unconditionally();
foo.outer_join(bar).unconditionally();
// No such thing.

< Differences