Feature: add support for SPLIT in DEFINE TABLE

[alialfred]

Is your feature request related to a problem?

I've been using SurrealDB for a while now and have encountered several scenarios where I need to create a view from a table that contains an array field. In these cases, I want to use the SPLIT feature, similar to the $unwind functionality in MongoDB, to separate the elements of the array into individual records.

Currently, my attempts to use the SPLIT feature in a DEFINE TABLE statement result in an error. Here is an example of the query I attempted:

DEFINE TABLE MyView AS SELECT a, arrayField FROM MyTable SPLIT arrayField;

The error message I received was:

expected query to end
  |
1 | DEFINE TABLE MyView AS SELECT a, arrayField FROM MyTable SPLIT arrayField...
  |        ^ perhaps missing a semicolon on the previous statement?

Describe the solution

To enhance SurrealDB, I suggest adding support for the SPLIT feature within the DEFINE TABLE statement. This would allow users to create views that effectively handle array fields by splitting them into separate records, making the database more versatile and powerful for complex data transformations.

Alternative methods

NONE

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