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
29
30
31
32

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

# INSERT, UPDATE, DELETE

transpile "INSERT INTO users (id, name) VALUES (1, 'Alice')"
---
INSERT users [{id: 1, name: 'Alice'}]

transpile 'INSERT INTO t (a, b) VALUES (1, 2), (3, 4)'
---
INSERT t [{a: 1, b: 2}, {a: 3, b: 4}]

transpile "UPDATE users SET name = 'Bob' WHERE id = 1"
---
UPDATE users {name: 'Bob'} FILTER {id == 1}

transpile 'DELETE FROM users WHERE id = 1'
---
DELETE users FILTER {id == 1}

transpile "INSERT INTO t1 VALUES (1, 'true')"
---
INSERT t1 [(1, 'true')]

transpile "INSERT INTO t1 VALUES (1, 'true'), (0, 'false')"
---
INSERT t1 [(1, 'true'), (0, 'false')]

transpile "INSERT INTO t1 VALUES (NULL, 'NULL')"
---
INSERT t1 [(none, 'NULL')]