Table: add new methods

See merge request !60

add Table::deleteAndGet() for situations where you need to delete a row by its PK and then further act upon its data

This introduces the upsert() method, as well as the upsertAndGet() variant. These insert a new row, or update the existing one if given primary key already exists, and do it atomically in a single database query.

This introduces two new methods, insertAndGet() and updateAndGet(), which do the same as insert() and update(), and then immediately return the affected row.

That is a somewhat useful pattern, and this change allows developers to do that in a single database query.

This introduces two new methods, Table::updateBy() and Table::deleteBy(), that allow developers to update or delete all rows matching given conditions.

Make TableManager/Connection more customizable

Closes #6

See merge request !59

Make nullability explicit (not only) in ArrayType and CompositeType

Closes #27

See merge request !58

Closes #27

Provide a wider selection of querying methods in Table.

Closes #29

See merge request !57

- getOneBy()
- findOneBy()
- getFirstBy()
- findFirstBy()

Also deprecate getBy() in favor of its replacement getOneBy()

Closes #29

chore: freshen this package up

See merge request !56

- bump PHP requirement to 8.2
- ensure compatibility with PHP 8.4
- update to PHPStan 2

fix empty orderBy on newer postgres versions

See merge request !55

add support for generated columns

See merge request !54

ci: test on all supported versions of php

See merge request !53

more robust creation/modification API

Closes #21 and #8

See merge request !50

- change new() and edit() to return changeSet
- split save() into insert(), update(), and insertOrUpdate()

allow dibi 5

See merge request !52