Core-2021.10.0 syntax error in SQL migration

Migration of MS SQL database fails with error "Incorrect syntax near ‘0’ "

SELECT statistics_meta.id AS statistics_meta_id, statistics_meta.statistic_id AS statistics_meta_statistic_id, statistics_meta.unit_of_measurement AS statistics_meta_unit_of_measurement, statistics_meta.has_mean AS statistics_meta_has_mean, statistics_meta.has_sum AS statistics_meta_has_sum 
FROM statistics_meta 
WHERE statistics_meta.has_sum IS NOT 0

should be:
WHERE statistics_meta.has_sum <> 0

Please do open an issue about this.

Already one for it. Schema migration error when upgrading to 2021.10 from 2021.9.7 using MSSQL · Issue #57194 · home-assistant/core (github.com)