reproducer

Program.cs

using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using Microsoft.EntityFrameworkCore;
using NodaTime;

AppContext.SetSwitch("Npgsql.EnableLegacyTimestampBehavior", true);

await using ApplicationDbContext db = new();
await db.Database.EnsureDeletedAsync();
await db.Database.EnsureCreatedAsync();

var today = new LocalDate(2023, 3, 30);
await db.WorkflowListViewWithPrices.Where(d => d.WorkflowDateCreated.Date >= today).CountAsync();

[Table("workflow_list_with_prices")]
public class WorkflowListElementWithPrice
{
    [Key]
    [Column("workflow_id")]
    public long WorkflowId { get; set; }

    [Required]
    [Column("workflow_date_created")]
    public ZonedDateTime WorkflowDateCreated { get; set; }
}

public class ApplicationDbContext : DbContext
{
    public DbSet<WorkflowListElementWithPrice> WorkflowListViewWithPrices { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        => optionsBuilder.UseNpgsql(
            "Host=localhost;Username=postgres;Password=postgres;Database=temp;",
            o => o.UseNodaTime());
}