AdonisJs blog queries via query builder

routes.js

// Display categories in the blog header
const categories = await Database.table('categories').select('*')

// Fetch posts for a category where category_id = 1
const posts = await Database
  .table('posts')
  .innerJoin('category_posts', 'posts.id', 'category_posts.post_id')
  .where('category_posts.category_id', categoryId)

// Select author for a given post
const author = await Database
  .table('users')
  .where('id', post.user_id)