MariaDB supports INSERT RETURNING and DELETE RETURNING, which help avoid an additional SELECT.
Rust shows the correct way to implement NULL in a programming language.
In MySQL/MariaDB one has to use ALTER TABLE to set a table comment. This is a problem in many situations.
There are cases when using NULL in an SQL database is desirable. However, there are always alternatives.
If you need free help or paid support, you should phrase your questions correctly and provide the necessary information.
Does NULL mean “no value”? Or does it mean “an unknown value”? Its semantics and history are ambiguous and inconsistent.
Any comparison involving at least one NULL operand will return NULL. However, SQL supports operators to easily write NULL-safe comparisons.