Are nested subqueries allowed?

[sandeep-biddala]

Are nested subqueries like the following allowed?

SELECT 
    customerName
FROM
    customers
WHERE
    customerNumber NOT IN (SELECT DISTINCT
            customerNumber
        FROM
            orders);

This is not mentioned in the doc.

Also, the docs mention that the min supported Go version is 1.12. However I had a problem with running the project with Go 1.12. The problem seems to be because of the usage errors.Is function which was only introduced in 1.15

Great job with the project BTW. I am enjoying it!

[tdakkota]

For now, subqueries and SELECT DISTINCT are not supported.

[asdine]

Also, the docs mention that the min supported Go version is 1.12. However I had a problem with running the project with Go 1.12. The problem seems to be because of the usage errors.Is function which was only introduced in 1.15

Thanks for reporting it @sandeep-biddala !

[tie]

The problem seems to be because of the usage errors.Is function which was only introduced in 1.15

Thanks for reporting it! One small note—errors.Is was introduced in Go 1.13.

@asdine do we have any policy on supporting different Go releases? E.g. Go project maintains the last two major releases (currently that’s 1.14 and 1.15, and that’s also what we test on Travis).

I think 1.12 was min because of some v2 dependencies that just don’t work without module support (i.e. v2 is not a subdirectory in the repo).

[asdine]

Our default policy was to maintain it for the last two major releases, but I'm open to suggestions. For now, since the project is still in the development phase, I'd like to limit friction as much as possible, so anything that is a good fit for both early adopters and for contributors works for me.