...But since nothing is being normalized (which you didn't want, probably still don't), we can skip most of the work. No merging, no splitting required.
We could have done the same "a few years ago" (!).
Let me know if I am missing something. I don't think so--I think I was missing the obvious in the version for 8.
VALUE @source_table TABLE = [Drawing Table];
VALUE @source_drawing TABLE = [Drawing];
CREATE TABLE [Simplified Table]
INDEX [mfd_id_x] BTREE ([mfd_id]),
INDEX [Geom_x] RTREE ([Geom]),
PROPERTY 'FieldCoordSystem.Geom' ComponentCoordSystem(@source_drawing)
CREATE DRAWING [Simplified]
PROPERTY 'FieldGeom' 'Geom',
PROPERTY 'Table' '[Simplified Table]'
INSERT INTO [Simplified Table]
([source_id], [Geom], [length])
GeomCoordXY([Geom], 0), -- start
GeomCoordXY([Geom], GeomCoordCount([Geom]) - 1) -- end
GeomLength([Geom], 0) AS [length]
Topology and path length simpler.sql