(-> messages
      (q/join users (q/where (= :users.id :sender)))
      (q/project [[:users.id :as :sender_id] [:users.realname :as :sender_name]])
      (q/join users (q/where (= :users.id :recipient)))
      (q/project [[:users.id :as :recipient_id] [:users.realname :as :sender_name]])))

; I want to alias the users table so this can work