Coast Query

coast-query.clj

(ns your-project
  (:require [coast.db :as db]))

(db/q '[:select author/id
                author/name
                post/id
                post/title
                post/body
        :joins author/posts
        :where [author/name ?author/name]
        :order post/created-at desc]
      {:author/name "you"})

; =>

[{:author/id 1
  :author/name "you"
  :post/id 1
  :post/title "title 1"
  :post/body "body 1"}
 {:author/id 1
  :author/name "you"
  :post/id 2
  :post/title "title 2"
  :post/body "body 1"}
 {:author/id 1
  :author/name "you"
  :post/id 3
  :post/title "title 3"
  :post/body "body 3"}]