Tools

SQL Generator

Generate deterministic SQL from safe templates or the custom builder.

Review before use

SQL Generator only generates query text. Review the query before running it against any database. This application never executes generated SQL.

Workflow Invoice

Update Payment Status dari banyak bulan

Invoice Tools mendeteksi bulan dan tahun dari Invoice ID lalu membuat statement terpisah per periode.

Buka Invoice SQL Mode

Template * Preset * Batch Size

Customer ID / Invoice ID List * Accepts newline, comma, quoted values, or a pasted SQL IN clause. IDs always remain quoted strings.

0 identifier terdeteksi Belum ada identifier terdeteksi.

Input: 0 · Unique: 0 · Duplikat: 0

ID Column * Location ID * Package ID * Marketing ID * Month * Year * Payment Service * Payment Method * Paid At *Pilih tanggal dan waktu pembayaran. Payment Status * Register Date * Existing Register Date

Advanced / Custom Builder Show / Hide

Identifiers accept letters, numbers, and underscore only.

SET fields (UPDATE)

WHERE filters

* Wajib diisi untuk template yang dipilih.

Reset Form

Advanced / Custom Presets

System presets are immutable. Custom presets are stored locally in SQLite.