We want to select the student record and the scores they got on a test. Here’s how we’d usually do that:

-- name: ScoreAndTests :many
SELECT students.*, test_scores.*
FROM students
JOIN test_scores ON test_scores.student_id = students.id
WHERE students.id = $1;
When using Go, sqlc will produce a struct like this:

type ScoreAndTestsRow struct {
	ID        int64
	Name      string
	Age       int32
	StudentID int64
	Score     int32
	Grade     string
}
With embedding, the struct will contain a model for both tables instead of a flattened list of columns.

-- name: ScoreAndTests :many
SELECT sqlc.embed(students), sqlc.embed(test_scores)
FROM students
JOIN test_scores ON test_scores.student_id = students.id
WHERE students.id = $1;
type ScoreAndTestsRow struct {
	Student   Student
	TestScore TestScore
}

WITH students AS (
  SELECT s.*
  FROM users s
  WHERE s.id = @id
), ...
SELECT
  s.*,
  ...
  ...
FROM students
WHERE s.id = ...