sea-query icon indicating copy to clipboard operation
sea-query copied to clipboard

Add pseudo tables

Open Huliiiiii opened this issue 4 months ago • 3 comments

Close #842

Huliiiiii avatar Sep 01 '25 01:09 Huliiiiii

Also, your current approach doesn't support asterisk, like NEW.* (literally * in the query)

This means the glob pattern, not the SQL asterisk.

Huliiiiii avatar Sep 02 '25 09:09 Huliiiiii

I understand. I'm pointing out that the SQL asterisk is also valid with these tables. I'd like to find a clean way to support it right away

Expurple avatar Sep 02 '25 09:09 Expurple

I think we could add an enum of pseudo tables/columns and regular idens. Basically it’s just raw idens vs regular ones. One hacky approach is to check in prepare_iden if the iden is one of the specific keywords.

Huliiiiii avatar Sep 02 '25 09:09 Huliiiiii