ROW keyword for tuples not yet supported

[forhsd]

1. execute the following SQL report error：ERROR: ROW keyword for tuples not yet supported
2. can execute normally in Postgres database
3. Doltgres version 0.50.0

select row(p) from users p

[fulghum]

Hi @forhsd, thanks for trying out doltgres and reporting this gap. We'll start digging into support for the ROW keyword and get this feature working.

Since ROW can be used in a few ways... are you specifically looking to support syntax like below, or is there a different usage you'd like us to prioritize?

SELECT * FROM employees
WHERE ROW(first_name, last_name) = ROW('John', 'Doe');

[bpf120]

Hi @forhsd , thanks again for the issues. We'd love to learn about your use case too. Feel free to email me or swing by our Discord if you'd like to share.

[fulghum]

Hi @forhsd, I've just merged in initial support for record types and the ROW() constructor function. Thanks for taking the time to submit this feature request. 🙏

There are still some uses of records that don't match Postgres' behavior (e.g. support for using ROW() with a table alias to wrap table rows). Don't hesitate to let us know if you hit any issues with records or ROW() or anything else in Doltgres and we'll be happy to dig in and help.