EF Core does not include boolean column with default value in SQL INSERT statement

[Gurgen]

When I set a boolean property with a default value in my entity and then try to add a new record with a value different from the default, EF Core generates an SQL INSERT statement without including that column.

Steps to reproduce:

1. Create an entity with a boolean property.
2. Configure the boolean property to have a default value of true.
3. Add a new entity with the boolean property set to false.
4. Notice that the generated SQL does not include the boolean column.

Expected behavior:
The SQL statement should include the boolean column with the value set to false.

Actual behavior:
The SQL statement does not include the boolean column, and the default value of true is always set.

EF Core version: 6.0.8
Database provider: Microsoft.EntityFrameworkCore.SqlServer
Target framework: .NET 6

[GertArnold]

See #7089. I've tried my best to explain why it's maddening. Apparently it's too deeply rooted in EF's logic based on CLR defaults to fix it.

[ajcvickers]

Duplicate of #701