[Feature] Support Iceberg branch/tag

[wuwenchi]

Search before asking

• I had searched in the issues and found no similar issues.

Description

• branch/tag read, like

SELECT * FROM [catalog.][db.]table@branch("test_branch");

-- 'branch_' is the fix prefix
SELECT * FROM [catalog.][db.]table VERSION AS OF 'branch_test_branch';

SELECT * FROM [catalog.][db.]table@branch("test_branch");

-- 'tag_' is the fix prefix
SELECT * FROM [catalog.][db.]table VERSION AS OF 'tag_test_branch';

If you want to check which branches/tags this table contains, you can use the system table refs to view them, like

select * from [catalog.][db.]table$refs;

and progress of the refs system table is included here #48278 .

• branch/tag create, like

ALTER TABLE [catalog.][db.]table
CREATE TAG tag_name AS OF VERSION version
[RETAIN num DAYS];

ALTER TABLE [catalog.][db.]table
CREATE BRANCH branch_name
[AS OF VERSION version]
[RETAIN num DAYS]
[WITH SNAPSHOT RETENTION num SNAPSHOTS];

• branch/tag drop, like

ALTER TABLE [catalog.][db.]table DROP BRANCH branch_name;
ALTER TABLE [catalog.][db.]table DROP TAG tag_name;

• branch/tag write, like

Insert into [catalog.][db.]table@branch("test_branch") values ();

Use case

No response

Related issues

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct