ayalma

@Query('SELECT * FROM article ORDER BY publishedAt DESC')
Stream<List<Article>> getAllArticles();

@Query('SELECT Author.*, _junction.articleId as articleId FROM ArticleAuthor AS _junction inner join Author ON (_junction.authorId = Author.id) WHERE _junction.articleId IN (:ids)')
Future<List<AuthorArticleId>> getAuthorsFromArticles(List<int> ids);

Stream<List<ArticleWithAuthor>> getAllArticlesWithAuthors() {
  final stream = getAllArticles();
  final controller = StreamController<List<ArticleWithAuthor>>.broadcast();