Describe the bug
Properly identify to_json()/to_jsonb() function output type
To Reproduce
select t1.*, to_json(t2.*) as col2 from table1 t1
join table2 t2 on t2.id = t1.table2_ref_id;
Expected behavior
This query selects all columns from table1 and joins all columns from table2 as col2. But safeql is identifying col2 as unknown rather that all columns of table2.
Desktop (please complete the following information):
Describe the bug Properly identify
to_json()/to_jsonb()function output typeTo Reproduce
Expected behavior This query selects all columns from table1 and joins all columns from table2 as col2. But safeql is identifying col2 as
unknownrather that all columns of table2.Desktop (please complete the following information):