SQL Server does support user-defined data types, but does not support table inheritance per-se. That's not to say you couldn't implement table inheritance with it, you'd just need an auxillary ...

By adding SQL pipelining capabilities, Prophecy significantly increases its addressable market,” he said. Prophecy 3.0 is now live and available on the Databricks lakehouse platform.