SELECT EXISTS (...) syntax not supported

[D1360-64RC14]

The following SQL throws an error:

row := r.db.QueryRow(`
    SELECT EXISTS (
        SELECT
            1
        FROM
            users
        WHERE
            id = ?
    );
`, id)

Syntax error near select exists (

I tried the exact same code on a real MySQL database, and it worked fine.

---

• GoLang version: 1.20
• In go.mod: github.com/proullon/ramsql v0.0.0-20230224205054-8ff679dbf7aa

[D1360-64RC14]

Also, some possible alternatives, like...

row := r.db.QueryRow(`
    SELECT
        COUNT(id) > 0
    FROM
        users
    WHERE
        id = ?;
`, id)

Syntax error near {6 >}\n

... and...

row := r.db.QueryRow(`
    SELECT
        COUNT(1) > 0
    FROM
        users
    WHERE EXISTS (
        SELECT
            1
        FROM
            users
        WHERE
            id = ?
    );
`, id)

Syntax error near ( 1 )

...didn't work.