Considering that your source database is using a completely different architecture compared to a massively distributed Fabric Warehouse, it is not surprising there is a feature gap between the two. Fabric Migration workload emulates many code constructs to achieve the same results your original code intended, in an idiomatic way appropriate for Fabric Warehouse.