reifydb-sql 0.6.0

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
21
22
23
24
25
26
27
28

# Copyright (c) reifydb.com 2026
# This file is licensed under the AGPL-3.0-or-later, see license.md file

# ORDER BY, LIMIT, OFFSET

transpile 'SELECT * FROM users ORDER BY name ASC'
---
FROM users SORT {name:asc}

transpile 'SELECT * FROM users ORDER BY age DESC'
---
FROM users SORT {age:desc}

transpile 'SELECT * FROM users ORDER BY dept ASC, name DESC'
---
FROM users SORT {dept:asc, name:desc}

transpile 'SELECT * FROM users ORDER BY name'
---
FROM users SORT {name:asc}

transpile 'SELECT * FROM users LIMIT 10'
---
FROM users TAKE 10

transpile 'SELECT * FROM users LIMIT 10 OFFSET 20'
---
FROM users TAKE 10 OFFSET 20