Names from the tree REP/S00 ← log/plant.db + LINE/L1, LINE/L2

--
The latest readings table his holds a time, a document, a point's id and a value — tree columns come from the point
timedocridname valunit
A rename is one write in the tree: every row of the point shows the new name at the next query, old rows too. The table was never told.
--
Search the names the table has no name to search
timeridnamevalunit
The engine finds the points whose desc holds the text (upper or lower case alike, contains-ci) and writes their ids into the SQL: rid IN ('L1_PT1','L2_PT1'). No point matches: IN (NULL), no row.
Work orders
wo_widwotitlemade state
The table knows an order by a number. {wo_wid:010X} makes its id in the tree, {wo_wid>>32:d} its line. A title the row has of its own stays (title ?=); the others come from the tree. open in the tree reads the ids back into numbers: ~ WO{:010X}.
The SQL what main.view writes to @qry every second; the /*xdb comments never reach the database