feat(sql)!: remove `number` and `scalar` data types

Summary

BREAKING CHANGE!

Remove NUMBER and SCALAR data types from SQL, because we don't really use them that much.

---

• Close Remove number and scalar data types (#873 - closed)
• Cherry-pick to: 24.7
• Docs follow-up: Удалить поддержку SCALAR и NUMBER типов данных (docs#401 - closed)
• Changelog is updated
• Follow-ups: #1326, #1327, #1350
• Merged into this request: !1598 (merged)