sqlglot-rust 0.9.24

A SQL parser, optimizer, and transpiler library inspired by Python's sqlglot
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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155

.PHONY: build test lint fmt sbom clean all bump-version \
       ffi ffi-header ffi-all ffi-macos-arm64 ffi-macos-amd64 ffi-linux-amd64 ffi-linux-arm64 \
       cli cli-target cli-macos-arm64 cli-macos-amd64 cli-linux-amd64 cli-linux-arm64 cli-all \
       dist dist-all \
       pkg-deb pkg-rpm

all: build sbom

build:
	cargo build

test:
	cargo test

lint:
	cargo clippy

fmt:
	cargo fmt

sbom:
	@echo "Generating SPDX SBOM..."
	@mkdir -p target/sbom
	cargo sbom --output-format spdx_json_2_3 > target/sbom/sqlglot-rust.spdx.json
	@echo "SBOM written to target/sbom/sqlglot-rust.spdx.json"

clean:
	cargo clean

# ── C/C++ FFI targets ────────────────────────────────────────────────────

FFI_OUT = target/ffi
HEADER  = $(FFI_OUT)/include/sqlglot.h

## Generate the C header with cbindgen
ffi-header: $(HEADER)
$(HEADER):
	@mkdir -p $(FFI_OUT)/include
	cbindgen --config cbindgen.toml --crate sqlglot-rust --output $(HEADER)
	@echo "Header written to $(HEADER)"

## Build for a single target (set TARGET, e.g. make ffi-target TARGET=aarch64-apple-darwin)
ffi-target: ffi-header
ifndef TARGET
	$(error TARGET is required. E.g. make ffi-target TARGET=aarch64-apple-darwin)
endif
	cargo build --release --target $(TARGET)
	@mkdir -p $(FFI_OUT)/$(TARGET)/lib
	@cp -f target/$(TARGET)/release/libsqlglot_rust.a  $(FFI_OUT)/$(TARGET)/lib/ 2>/dev/null || true
	@cp -f target/$(TARGET)/release/libsqlglot_rust.so $(FFI_OUT)/$(TARGET)/lib/ 2>/dev/null || true
	@cp -f target/$(TARGET)/release/libsqlglot_rust.dylib $(FFI_OUT)/$(TARGET)/lib/ 2>/dev/null || true
	@echo "Built FFI libraries for $(TARGET) → $(FFI_OUT)/$(TARGET)/lib/"

## Convenience per-platform targets
ffi-macos-arm64:
	$(MAKE) ffi-target TARGET=aarch64-apple-darwin

ffi-macos-amd64:
	$(MAKE) ffi-target TARGET=x86_64-apple-darwin

ffi-linux-amd64:
	$(MAKE) ffi-target TARGET=x86_64-unknown-linux-gnu

ffi-linux-arm64:
	$(MAKE) ffi-target TARGET=aarch64-unknown-linux-gnu

## Build for the current host only
ffi: ffi-header
	cargo build --release
	@mkdir -p $(FFI_OUT)/lib
	@cp -f target/release/libsqlglot_rust.a      $(FFI_OUT)/lib/ 2>/dev/null || true
	@cp -f target/release/libsqlglot_rust.so     $(FFI_OUT)/lib/ 2>/dev/null || true
	@cp -f target/release/libsqlglot_rust.dylib  $(FFI_OUT)/lib/ 2>/dev/null || true
	@echo "Built FFI libraries for host → $(FFI_OUT)/lib/"

## Build all four platform/arch combinations
ffi-all: ffi-macos-arm64 ffi-macos-amd64 ffi-linux-amd64 ffi-linux-arm64
	@echo "All FFI targets built → $(FFI_OUT)/"

# ── CLI cross-compilation targets ─────────────────────────────────────────

CLI_OUT = target/cli

## Build CLI for a single target (set TARGET)
cli-target:
ifndef TARGET
	$(error TARGET is required. E.g. make cli-target TARGET=aarch64-apple-darwin)
endif
	cargo build --release --features cli --target $(TARGET)
	@mkdir -p $(CLI_OUT)/$(TARGET)/bin
	@cp -f target/$(TARGET)/release/sqlglot $(CLI_OUT)/$(TARGET)/bin/ 2>/dev/null || true
	@echo "Built CLI for $(TARGET) → $(CLI_OUT)/$(TARGET)/bin/sqlglot"

## Convenience per-platform CLI targets
cli-macos-arm64:
	$(MAKE) cli-target TARGET=aarch64-apple-darwin

cli-macos-amd64:
	$(MAKE) cli-target TARGET=x86_64-apple-darwin

cli-linux-amd64:
	$(MAKE) cli-target TARGET=x86_64-unknown-linux-gnu

cli-linux-arm64:
	$(MAKE) cli-target TARGET=aarch64-unknown-linux-gnu

## Build CLI for the current host
cli:
	cargo build --release --features cli
	@mkdir -p $(CLI_OUT)/bin
	@cp -f target/release/sqlglot $(CLI_OUT)/bin/ 2>/dev/null || true
	@echo "Built CLI for host → $(CLI_OUT)/bin/sqlglot"

## Build CLI for all four targets
cli-all: cli-macos-arm64 cli-macos-amd64 cli-linux-amd64 cli-linux-arm64
	@echo "All CLI targets built → $(CLI_OUT)/"

# ── Combined distribution targets ────────────────────────────────────────

## Build FFI + CLI for the current host
dist: ffi cli
	@echo "Distribution built for host → target/ffi/ + target/cli/"

## Build FFI + CLI for all four targets
dist-all: ffi-all cli-all
	@echo "Full distribution built for all targets"

# ── Linux packaging targets ──────────────────────────────────────────────

## Build a Debian package (requires cargo-deb; run on Linux after `make ffi cli`)
pkg-deb: ffi cli
	cargo deb --no-build --no-strip
	@echo "Debian package built → target/debian/"

## Build an RPM package (requires cargo-generate-rpm; run on Linux after `make ffi cli`)
pkg-rpm: ffi cli
	cargo generate-rpm
	@echo "RPM package built → target/generate-rpm/"

# ── Version management ───────────────────────────────────────────────────
bump-version:
ifndef VERSION
	$(error VERSION is required. Usage: make bump-version VERSION=1.2.3)
endif
	@echo "$(VERSION)" | grep -qE '^[0-9]+\.[0-9]+\.[0-9]+$$' || \
		{ echo "Error: VERSION must be a full semantic version (MAJOR.MINOR.PATCH), e.g. 1.2.3"; exit 1; }
	@echo "Bumping version to $(VERSION)..."
	@# Update Cargo.toml
	sed -i '' 's/^version = ".*"/version = "$(VERSION)"/' Cargo.toml
	@# Update version in documentation
	sed -i '' 's/sqlglot-rust = "[^"]*"/sqlglot-rust = "$(VERSION)"/' README.md
	sed -i '' 's/sqlglot-rust = "[^"]*"/sqlglot-rust = "$(VERSION)"/' docs/installation.md
	@# Sync Cargo.lock
	cargo generate-lockfile
	@echo "Version updated to $(VERSION)"