Query Examples

[parkerl]

• [x] distinct
  • [x] generic
  • [x] with query expression
  • [x] with order by
• [ ] from
  • [x] basic
  • [ ] with multiples
• [x] group_by
• [x] having
• [x] join
  • [x] basic
  • [x] with fragment
• [x] limit
• [ ] first
• [ ] last
• [ ] lock
• [x] offset
• [x] order_by
  • [x] basic
  • [x] DESC
  • [x] with atom field names
  • [x] interpolated kw list
• [ ] preload
  • [ ] basic
  • [ ] with joins
  • [ ] nested
  • [ ] with a query
• [x] select
• [ ] update
  • [ ] basic
  • [ ] increment
  • [ ] push
  • [ ] pull
• [x] where
• [ ] exclude
• [ ] subquery
• [ ] map update syntax. Example: from p in Post, select: %{p | title: "fixed"}
• [ ] custom select field in preload queries
• [ ] struct fields to be selected with struct/2 and map fields with map/2, including support for dynamic fields
• [ ] :on field to be specified with association joins
• [ ] Support prepared queries in adapters