Semantic
Tables containing relations between records can be loaded through a semantic prefix. This can for example be self-references within a table, where one record points to another, such as parent, belongs to, or predecessor.
Syntax:
Semantic( loadstatement | selectstatement)
The semantic load will create semantic fields that can be displayed in list boxes to be used for navigation in the data.
Tables loaded through a semantic statement cannot be concatenated.
Example:
Semantic LOAD * from abc.csv;
Semantic SELECT Object1, Relation, Object2, InverseRelation from table1;