Looks up a single group by ID. Returns null if not discovered yet.
Future<Group?> getGroupById(String groupId) { return (select(groups)..where((t) => t.groupId.equals(groupId))) .getSingleOrNull(); }