Takes care of the built-in aggregates only for now (Min/Max/etc.)

Part of #727

Fixes #2389

Fixes #2379

* Fix nested set operations with leftmost nulls

Fixes #2366

Fixes #2374

Unwrap Convert node to ITuple specifically in translation of the row
value comparison methods.

See https://github.com/dotnet/efcore/pull/27964

Closes #2215

Fixes #2351

As a nicer alternative to new ValueTuple<T1, T2>(...)

And stop explicitly specifying the version in our CI workflow
(use global.json)

Closes #2349

Fixes #2342

Daily 7.0.100-preview.4.22175.5 has issues with debugging tests

EF Core -> 7.0.0-preview.4.22176.1
Npgsql -> 7.0.0-preview.3

* Avoid time zone conversion when translating DateTime.Date with
  timestamptz.
* Return PG date from NodaTime {Local,Zoned}DateTime.Date

Fixes #2333
Fixes #2335

To remove dependency on external dependency (security)

The PG parameter limit is per statement, not per batch.

EF Core -> 7.0.0-preview.4.22176.1

Switched to dotnet sdk 7.0.100-preview.4.22175.5, because preview2 has
an issue (https://github.com/dotnet/runtime/issues/66056)

EF Core -> 7.0.0-preview.3.22175.1

Fixes #2305