select
			shortcut.column_1 as returned_column_1,
			shortcut.column_2 as returned_column_2,
			(...)
			-- далее идут колонки, вычисляемые на основе колонок shortcut.* (и таблиц, участвующих в запросе)
			-- пример (из головы):
			case shortcut.some_more_column
				when 1 then shortcut.column_1
				when 2 then shortcut.column_2
				else some_udf(t0.some_column_1, t1.some_column_1, t2.some_column_1)
			end as some_calculated_column,
			(...)
		from some_table t0
			left join some_table t1
				on (...)
			left join some_table t2
				on (...)
			(...)
			left join some_table tN
				on (...)
			cross join lateral (
				select
						coalesce(tN.some_column_1, (...), t2.some_column_1, t1.some_column_1, t0.some_column_1) as column_1,
						coalesce(tN.some_column_2, (...), t2.some_column_2, t1.some_column_2, t0.some_column_2) as column_2,
						(...)
						case
							when tN.some_column_1 is not null then tN.some_column_2
							(...)
							when t2.some_column_1 is not null then t2.some_column_2
							when t1.some_column_1 is not null then t1.some_column_2
						end as some_more_column,
						(...)
					from dual) shortcut