This is how it is done in ClickHouse. It has Nullable(T) type. The functions of non-Nullable types will return non-Nullable types (except some specific functions).
https://clickhouse.tech/docs/en/sql-reference/data-types/nul...
you can use COALESCE to remove nulls
Explanation for your downvotes: you misunderstood GP's post, he refers to removing the concept of null as it is currently specified from the language, not removing null values from data.
> It would be really cool if databases had an Option<T> type. Then you could remove all the NULLs.
A nullable T column _is_ an Option<T> column, with NULL representing "Empty" or "No Value".
I'm curious how much work has been done on optimizers for Tutorial D or other D variants. It looks way nicer to use, but I wonder if it is easier to stumble into pathological cases.