sqlc generate
# queries/users.sql:2:26: column "display_label" does not exist

-- ./migrations/001_create_users.sql

-- +goose Up
CREATE TABLE users (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    label VARCHAR(255) NOT NULL
);

-- +goose Down
DROP TABLE users;

-- ./migrations/002_rename_columns.sql

-- +goose Up
ALTER TABLE users
    RENAME COLUMN name TO display_name,
    RENAME COLUMN label TO display_label;

-- +goose Down
ALTER TABLE users
    RENAME COLUMN display_name TO name,
    RENAME COLUMN display_label TO label;

-- name: GetUserByID :one
SELECT id, display_name, display_label
FROM users
WHERE id = ?;

version: "2"
sql:
  - schema: "migrations"
    queries: "queries"
    engine: "mysql"
    gen:
      go:
        out: "gen"