Custom query generated type missing nullables about drift

[simolus3]

Thanks for the report! Yeah, this looks like a bug and we should make subquery expressions nullable.

[simolus3]

This will (well, should) be fixed in the next release. If you give me the definition of entry_rows I can check that it works with your query, it might be something else when the type inference has to jump through many steps (like here with the CTEs).

[hamishjohnson]

Great 👍🏼

class EntryRows  {
  TextColumn get taskId => text()();
  TextColumn get date => text()();
  IntColumn get amount => integer()();
  BoolColumn get skip => boolean()();
}

Let me know if you need anything else

[simolus3]

Well the table is missing an extends Table and a deleted column referenced in the query, but I can confirm that the fields are nullable as they should be with that fix.