selectID

For example:

// SELECT id FROM player
let request = try Player.selectID()

Important: if the record type has an ID type that is an optional, such as Int64?, it is recommended to prefer selectPrimaryKey(as:) instead:

struct Player: Identifiable {
    var id: Int64?
}

// NOT RECOMMENDED: Set<Int64?>
let ids = try Player.selectID().fetchSet(db)

// BETTER: Set<Int64>
let ids = try Player.selectPrimaryKey(as: Int64.self).fetchSet(db)