reifydb-sql 0.4.13

SQL to RQL transpiler
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

# Copyright (c) reifydb.com 2025
# This file is licensed under the Apache-2.0, see license.md file

# GROUP BY, AGGREGATE, HAVING

transpile 'SELECT COUNT(id) FROM users GROUP BY dept'
---
FROM users AGGREGATE {math::count(id)} BY {dept}

transpile 'SELECT dept, COUNT(id) FROM users GROUP BY dept'
---
FROM users AGGREGATE {math::count(id)} BY {dept}

transpile 'SELECT COUNT(id), SUM(salary) FROM users GROUP BY dept'
---
FROM users AGGREGATE {math::count(id), math::sum(salary)} BY {dept}

transpile 'SELECT COUNT(id) FROM users GROUP BY dept HAVING COUNT(id) > 5'
---
FROM users AGGREGATE {math::count(id)} BY {dept} FILTER {math::count(id) > 5}