Compared with SQL statements of niub, SQL statements can be nested queries and sorted by temporary field names.

Select column_id, column_name, parent_id, (select column_name from [sort] Where column_id = A. parent_id) parent_name,
(Select parent_id from [sort] Where column_id = A. parent_id) fathers_id,
(Select column_name from [sort] Where column_id = (select parent_id from [sort] Where column_id = A. parent_id) father_name
From [sort] A where column_depth = 3 order by father_name DESC, parent_name DESC, column_name DESC

Compared with SQL statements of niub, SQL statements can be nested queries and sorted by temporary field names.