SQLDelight Join Result

@AutoValue public abstract class LibraryInfo implements Library.SelectByWithAppCountModel {
  public static final RowMapper<LibraryInfo> MAPPER =
      new LibraryModel.SelectWithAppCountMapper<>(LibraryInfo::create);

  public static LibraryInfo create(String id, String title, long appCount) {
    return new AutoValue_LibraryInfo(id, title, appCount);
  }
}


# SQLDelight:
Library.sq

selectWithAppCount:
SELECT Library.id, Library.title, Count(appId) AS appCount
FROM Library LEFT OUTER JOIN LibraryApp
ON Library.id = LibraryApp.libraryId
WHERE Library.type = ?
GROUP BY Library.id;