table not available error for query with LEFT JOIN LATERAL

[valichek]

sqlvet fails with:

ERROR: table `w` not available for query

on query similar to:

SELECT d.id, coalesce(w.w_count,0) as w_count FROM my_table AS d
LEFT JOIN LATERAL ( 
    SELECT count(*) as w_count FROM my_another_table WHERE d.id = ext_id AND deleted_at IS NULL
) w ON true
WHERE d.deleted_at IS NULL;

[samiam2013]

Can you alias with AS w? or is that disallowed by postgres/does it fail in the same way?

[valichek]

Can you alias with AS w? or is that disallowed by postgres/does it fail in the same way?

Using AS w is valid option for postgres with same result, anyway it still fails with the same sqlvet error

SELECT d.id, coalesce(w.w_count,0) as w_count FROM my_table AS d
LEFT JOIN LATERAL ( 
    SELECT count(*) as w_count FROM my_another_table WHERE d.id = ext_id AND deleted_at IS NULL
) AS w ON true
WHERE d.deleted_at IS NULL;

[houqp]

I think the join clause parsing logic needs to be extended to handle table aliases so w can be registered as a table in ctx.schema on the fly:

sqlvet/pkg/vet/vet.go

Line 196 in 4e66a98

func getUsedColumnsFromJoinClauses(fromClauseList []*pg_query.Node) []ColumnUsed {