Filter out null values in SQL and resulting type

[Akxe]

Problem

model Carrier {
  id   Int;
  lat? Float;
  lng? Float;
}

const carriers = await prisma.carrier.findMany({
  select: {
    id: true,
    lat: true,
    lng: true,
  },
  where: {
    lat: { not: { equals: null } },
    lng: { not: { equals: null } },
  },
});

// This now results in "number | null", but it very much should be "number"
carriers[0].lat

Suggested solution

I would prefer using a syntax like this:

const carriers = await prisma.carrier.findMany({
  select: {
    id: true,
    lat: 'notNull',
    lat: 'notNull',
  },
});

This is very descriptive that the lat and lng are only fetched if they are not null and it would remove a lot of unnecessary where clauses.

Alternatively, it could be done via the where clause, but the types would need to be fixed.

const carriers = await prisma.carrier.findMany({
  select: {
    id: true,
    lat: true,
    lng: true,
  },
  where: {
    lat: { not: { equals: null } },
    lng: { not: { equals: null } },
  },
});

Alternatives

Fixing type at runtime...

Additional context

Possible fix to this: #15074 - We could use the custom query to define a query that would fix the types, but it is a lot of manual work just in different a file...

[Akxe]

@danstarns, although I would love for this to be fixed, I do not think this qualifies as a bug but rather a feature.