In SELECT
part of the query, introduce a new special column "Link type" (@link_type
).
SELECT
It displays a column with the link, with the Forward label for Forward links and Reverse for Reverse links. Links without type give an empty cell.
WHERE & ORDER BY
As of today, the links are not filtered yet, the behavior of WHERE and ORDER BY branches of the query is not yet defined. Waiting for feedback from real usage.