From 9abe1e72043062bc35a243e1c2f7027fde42b814 Mon Sep 17 00:00:00 2001
From: Alexander Foremny <aforemny@posteo.de>
Date: Wed, 7 Feb 2024 02:32:13 +0100
Subject: support joins

---
 README.md | 33 +++++++++++++++++++++++++++++++++
 1 file changed, 33 insertions(+)
 create mode 100644 README.md

(limited to 'README.md')

diff --git a/README.md b/README.md
new file mode 100644
index 0000000..c9eba83
--- /dev/null
+++ b/README.md
@@ -0,0 +1,33 @@
+```console
+❯ tree data/
+data/
+├── c
+│   ├── 1.json
+│   └── 2.json
+└── j
+    ├── 1.json
+    └── 2.json
+```
+
+```console
+> SELECT . FROM c
+{"id":2,"j_id":3}
+{"foo":"bar","id":1,"j_id":1}
+
+> SELECT id FROM c
+{"c.id":2}
+{"c.id":1}
+
+> SELECT c.id, j.id, is_j FROM c LEFT JOIN j ON j.id == c.j_id
+{"c.id":2,"is_j":null,"j.id":null}
+{"c.id":1,"is_j":true,"j.id":1}
+
+> SELECT c.id, j.id FROM c RIGHT JOIN j ON j.id == c.j_id
+{"c.id":null,"j.id":2}
+{"c.id":1,"j.id":1}
+
+> SELECT c.id, j.id FROM c FULL JOIN j ON j.id == c.j_id
+{"c.id":2,"j.id":null}
+{"c.id":1,"j.id":1}
+{"c.id":null,"j.id":2}
+```
-- 
cgit v1.2.3