[LucaCappelletti94]

SELECT * FROM ONLY t parsed as a table named ONLY aliased t. It displayed back unchanged, so round-trip tests could not see it, while the relation visitor reported ONLY instead of t. ONLY (t) became a call to a function ONLY, and ONLY t AS x, t* and app.t* AS x failed to parse. UPDATE and DELETE behaved the same. PostgreSQL 16 accepts all of them (https://www.postgresql.org/docs/current/sql-select.html#SQL-FROM).

TableFactor::Table now carries an inheritance field, parsed when the new Dialect::supports_table_inheritance_markers holds, which PostgreSQL and Generic enable. It holds an enum since PostgreSQL accepts at most one of the two markers on a table, and Only records whether the name was parenthesized so that ONLY (t) displays as written. A table named only stays reachable as "only".

[codecov-commenter]

Codecov Report

✅ All modified and coverable lines are covered by tests.
✅ Project coverage is 82.62%. Comparing base (1e0bc45) to head (f070ff4).

Additional details and impacted files

@@            Coverage Diff             @@
##             main    #2770      +/-   ##
==========================================
+ Coverage   82.61%   82.62%   +0.01%     
==========================================
  Files          42       42              
  Lines       35614    35632      +18     
  Branches    35614    35632      +18     
==========================================
+ Hits        29421    29441      +20     
  Misses       2659     2659              
+ Partials     3534     3532       -2     

☔ View full report in Codecov by Harness.
📢 Have feedback on the report? Share it here.

🚀 New features to boost your workflow:

• ❄️ Test Analytics: Detect flaky tests, report on failures, and find test suite problems.

[s5dsn-eqee]

LGTM!

[LucaCappelletti94]

Thanks @s5dsn-eqee for the review, I will be merging this one now.

cc @alamb