I think the SQL DML is far from optimal but it mostly works, even though it is quite difficult to use for some cases. It will be with us for a long time. SQL D

I think the SQL DML is far from optimal but it mostly works, even though it is quite difficult to use for some cases. It will be with us for a long time. SQL DDL, on the other hand, is broken as a standard because it assumes implementation details of the database engine that were widely true when it SQL was designed but are nonsensical or increasingly divergent in modern database engine architectures e.g. the many tacit assumptions about index properties.