ALT // Union of source collections: const feed = createLiveQueryCollection((q) => q .unionAll({ message: messages, toolCall: toolCalls, }) .orderBy(({ message, toolCall }) => coalesce(message.timestamp, toolCall.timestamp), ), ) // Union over multiple quires: const feed = createLiveQueryCollection((q) => { const messageRows = q .from({ message: messages }) .select(({ message }) => ({ kind: `message` as const, id: message.id, body: message.text, timestamp: message.timestamp, })) const toolCallRows = q .from({ toolCall: toolCalls }) .select(({ toolCall }) => ({ kind: `toolCall` as const, id: toolCall.id, body: toolCall.name, timestamp: toolCall.timestamp, })) return q .unionAll(messageRows, toolCallRows) .orderBy(({ timestamp }) => timestamp) })

ALT // Catagorising a row based a on a value: const userCategories = createLiveQueryCollection((q) => q .from({ user: usersCollection }) .select(({ user }) => ({ id: user.id, name: user.name, email: user.email, category: caseWhen( gt(user.age, 65), 'senior', gt(user.age, 18), 'adult', 'minor', ), })) ) // Conditional includes: const preiumProfiles = createLiveQueryCollection((q) => q .from({ user: usersCollection }) .select(({ user }) => ({ ...user, posts: caseWhen(eq(user.accountType, 'premium'), q .from({ post: postsCollection }) .where(({ post }) => eq(post.userId, user.id)) .select(({ post }) => ({ id: post.id title: post.title, timestamp: post.timestamp })), ), })) )