ParseError from DEFINE TABLE with subquery

Describe the bug

SELECT * FROM (SELECT * FROM foo) appears to be a valid query and produces the same result as SELECT * FROM foo. However, DEFINE TABLE bar AS SELECT * FROM (SELECT * FROM foo) throws a ParseError.

Steps to reproduce

CREATE foo SET name = 'tom';
SELECT * FROM (SELECT * FROM foo); // [ { name: 'tom' } ]
DEFINE TABLE bar AS SELECT * FROM foo;
SELECT * FROM bar; // [ { name: 'tom' } ]
DEFINE TABLE baz AS SELECT * FROM (SELECT * FROM foo); // ParseError
SELECT * FROM baz; // Expected: [ { name: 'tom' } ]

Expected behaviour

It probably should not be a parse error.

SurrealDB version

1.0.0-beta.8+20221221.157f7c8 for unknown on unknown

Contact Details

[email protected]

Is there an existing issue for this?

• I have searched the existing issues

Code of Conduct

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