Haybarn SQL functions

SELECT list_transform(
  [12, 24, 36],
  lambda price: price * 1.2
) AS prices_with_tax;

SELECT regexp_replace(
  lower(trim('  Summer Harvest 2026  ')),
  '\s+', '-', 'g'
) AS slug;

SELECT
  date_trunc('month', sold_at) AS month,
  sum(amount) AS revenue
FROM (VALUES
  (DATE '2026-06-03', 120),
  (DATE '2026-06-18', 85),
  (DATE '2026-07-02', 150)
) AS sales(sold_at, amount)
GROUP BY 1 ORDER BY 1;

SELECT json_extract_string(
  '{"farm":"Willow Creek","crops":["apples","pears"]}',
  '$.farm'
) AS farm;