sqlc/internal/endtoend/testdata/sqlc_embed/mysql/query.sql at 4b157be9183d66bb80be3c7c5f5821bbed91b8b4 · sqlc-dev/sqlc · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
-- name: Only :one
SELECT
    sqlc.embed (users)
FROM
    users;

-- name: WithAlias :one
SELECT
    sqlc.embed (u)
FROM
    users u;

-- name: WithSubquery :many
SELECT
    sqlc.embed (users),
    (
        SELECT
            count(*)
        FROM
            users
    ) AS total_count
FROM
    users;

-- name: WithAsterisk :one
SELECT
    sqlc.embed (users),
    *
FROM
    users;

-- name: Duplicate :one
SELECT
    sqlc.embed (users),
    sqlc.embed (users)
FROM
    users;

-- name: Join :one
SELECT
    sqlc.embed (users),
    sqlc.embed (posts)
FROM
    posts
    INNER JOIN users ON posts.user_id = users.id;

-- name: WithSchema :one
SELECT
    sqlc.embed (bu)
FROM
    baz.users bu;

-- name: WithCrossSchema :many
SELECT
    sqlc.embed (users),
    sqlc.embed (bu)
FROM
    users
    INNER JOIN baz.users bu ON users.id = bu.id;

-- name: WithSpaceBeforeParen :one
SELECT
    sqlc.embed (users)
FROM
    users;