Upgrade SQLx dependency to 0.6.x

[billy1624]

Motivation

Upgrading SQLx dependency as well as the downstream dependencies such as time, uuid, bigdecimal, etc.

Tasks

• Upgrade to SQLx 0.6.x
• Upgrade to time 0.3.x
  • upgrade time to 0.3.x version #340
• Upgrade to uuid 1.x
  • Enable UUID v1.0 for Postgres #325
• Update the drivers (sqlx, postgres and rustqlite) to bind all upgraded value types
• Upgrade to bigdecimal 0.3.x

Additional Information

Potential Breaking Changes

• Sqlite chrono::DateTime<FixedOffset> timezone fix launchbadge/sqlx#1618
  SQLite chrono::DateTime<FixedOffset> timezone fix
  • DateTime<FixedOffset> will be stored in SQLite with the correct timezone instead of always in UTC.
    This was flagged as a "potentially breaking change" since it changes how dates are sent to SQLite.
• pool fixes and breaking changes launchbadge/sqlx#1901
  Pool fixes and breaking changes
  • Renamed PoolOptions::connect_timeout to acquire_timeout for clarity.

[ikrivosheev]

@billy1624 please, add bigdecimal to Tasks.

[billy1624]

Hey @ikrivosheev, feel free to edit my comment :)

[ikrivosheev]

@billy1624 @tyt2y3 I think we need to agree! Support both time, uuid, bigdecimal versions or support only latest?

[tyt2y3]

I think we should only support latest

[ikrivosheev]

@tyt2y3 sounds good

[tyt2y3]

Okay. So after some thought, I think our dependency policy would be follows: we only support the latest release of an upstream dependency, and in SeaORM we simply follow whatever version SQLx uses.

So in some cases, we need to maintain a branch of sea-query to support sea-orm while sea-query keep upgrading dependencies even before SQLx upgrades them

[tyt2y3]

I realize that it's a much less maintenance burden to backport features to an older branch than to trying to make it all work together in one codebase, given that in practice, no meaningful code change is required to switch dependency version (for the most part they compile!).

[tyt2y3]

So at any time we only maintain two sea-query branches, the latest master and whatever version sea-orm is pinned to.

[ikrivosheev]

@tyt2y3 I add PR

[ikrivosheev]

@tyt2y3 I think we can close this issue, because sqlx is upgraded.

[tyt2y3]

So cool, I am waiting the moment the CI passes

[ikrivosheev]

Cool! CI pass: https://github.com/SeaQL/sea-query/actions/runs/2596551981