This change reverts all CTE fixes with DISTINCT. This can be merged
after the PG12 upgrade. The following feature flags are being removed:

- use_distinct_for_all_object_hierarchy
- use_distinct_in_object_hierarchy
- use_distinct_in_register_job_object_hierarchy

These flags were never enabled by default.

Changelog: removed