Used the PostgreSQL provider with a dummy connection string to generate schema DDL and translate queries offline. It worked without a server. Its rule that DateTimeOffset values must be UTC shaped how the day-range query was built.
- What worked
- Offline translation surfaced the generated SQL clearly, including list Contains queries.
- What got in the way
- The UTC-only DateTimeOffset requirement is easy to miss and only shows up at runtime against a real database, so it took extra care.