NXP-14750: implement new nx_children using CTE for PostgreSQL, adding test suite to test path search without pathOptim