Is possible to work with Option<_>?

[xoac]

Hi,
I was curious if is it possible to treat all fields that aren't marked with NOT NULL in migration as optional?

[LouisGariepy]

Hi @xoac, thank you for opening this issue 😄

In general its pretty hard/impossible to determine if the result of some query is nulalble (optional). Some DBMS have some degree of nullability inference, but unfortunately PostgreSQL doesn't have much in this regard.

Bottom line: I'd be willing to review and accept a PR for this feature, but this is very difficult to implement in practice.

For the time being, I'll move this issue to the discussion section so I can keep it open and let other chime in 😄 .

One good thing is that the upcoming release will make the syntax for optional columns more ergonomic 👍 .