Updated the `postgres` package to version `3.0.0`

[BreX900]

• You no longer need to use the Database class, you can use Connection.open or Pool directly.

  • Database class implements postegres Session and SessionExecutor classes
  • Extension methods for accessing repositories now extend Session
  • Added the ability to create a Pool for your database

  BREAKING CHANGES

  • Updated the postgres package to version 3.0.0. To visit all the breaking changes see their changelog
  • Removed Database.query method in favour of Session.execute method
  • Action and Query now accept a Session
  • Repository methods are no longer wrapped in a transaction
  • Removed all fields and methods to execute a transaction in favor of SessionExecutor.runTx

Blocked by #70

Fixs #69 #5

[BreX900]

@schultek Is there any possibility to merge the PR or is the repo no longer maintained?

[schultek]

Sry I haven't been showing much love to the package. I try to review the PR over the next days and get back to working on it some more.

And thanks for the PR.

[codecov-commenter]

Codecov Report

Attention: 56 lines in your changes are missing coverage. Please review.

Comparison is base (04933b7) 63.90% compared to head (51f3808) 62.45%.

Files	Patch %	Lines
lib/src/core/database.dart	38.70%	38 Missing :warning:
lib/src/cli/migration/patcher.dart	37.50%	10 Missing :warning:
lib/src/internals/insert_repository.dart	40.00%	3 Missing :warning:
lib/src/builder/generators/insert_generator.dart	66.66%	2 Missing :warning:
lib/src/internals/text_encoder.dart	33.33%	2 Missing :warning:
lib/src/internals/base_repository.dart	0.00%	1 Missing :warning:

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #71 +/- ## ========================================== - Coverage 63.90% 62.45% -1.45% ========================================== Files 37 37 Lines 1507 1505 -2 ========================================== - Hits 963 940 -23 - Misses 544 565 +21 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.