Cross-Platform Swift: Building a Swift App for the Browser
pointfree.co4 pointsby mbw2340 comments
@Table struct RemindersList {
let id: UUID
var title = ""
}
@Table struct Reminder {
let id: UUID
var title = ""
var remindersListID: RemindersList.ID
}
#sql("""
SELECT \(RemindersList.title), \(Reminder.id.count())
FROM \(RemindersList.self)
LEFT JOIN \(Reminder.self) ON \(RemindersList.id) = \(Reminder.remindersListID)
GROUP BY \(RemindersList.id)
""",
as: (String, Int).self
)