Cannot reference multiple tables

[clive819]

Description

This doesn't compile

@Table struct A {

    // ✅
    var single: B.ID

    // ❌
    var array: [B.ID]

    // ❌
    var dictionary: [B.ID: Double]
}

@Table struct B: Identifiable {

    let id: UUID
}

Checklist

• I have determined whether this bug is also reproducible in a vanilla SwiftUI project.
• I have determined whether this bug is also reproducible in a vanilla GRDB project.
• If possible, I've reproduced the issue using the main branch of this package.
• This issue hasn't been addressed in an existing GitHub issue or discussion.

Expected behavior

The code should compile

Actual behavior

Reproducing project

No response

SharingGRDB version information

No response

Sharing version information

No response

GRDB version information

No response

Destination operating system

No response

Xcode version information

Version 16.2 (16C5032a)

Swift Compiler version information

[mbrandonw]

Hi @clive819, the array and dictionary fields of your type are not types that can be natively stored in SQLite. You must perform an extra step to describe how to transform these types into something that SQLite does understand. This is documented here.

Since this isn't an issue with the library I am going to convert it to a discussion. Please feel free to continue the conversation over there!