mixfix version of as function

Stands for AS

Examples

import Ecto.Query
import Ecto.Query.Timescaledb

from(s in Stat,
  select: as(sum(s.avg), avg),
  order_by: [desc: fragment("avg")]
)

histogram

Examples

import Ecto.Query
import Ecto.Query.Timescaledb

from(r in Readings,
  select: [r.device_id, histogram(r.battery_level, 20, 60, 5)],
  group_by: r.device_id,
  limit: 10
)

time_bucket extension in timescaledb

Examples

import Ecto.Query
import Ecto.Query.Timescaledb

from(s in Stat,
  select: [time_bucket("7 days", time, bucket), sum(s.avg)],
  group_by: fragment("bucket"),
  order_by: [desc: fragment("bucket")]
)

time_bucket_ng extension in timescaledb