Szymon Skirgajłło

DbGate is a lightweight, fast, and user-friendly SQL client. It launches quickly, has a clean interface, and handles browsing and editing data smoothly even with larger datasets. One issue I’ve encountered is with complex SQL queries — for example queries using WITH CTEs combined with multiple UNIONs. DbGate doesn’t always recognize the whole statement as a single query. Instead, it seems to treat individual parts separately, so pressing Run current query often executes only the first SELECT. The workaround is to manually select the entire query block and run it as a selection, which works fine. It would be great if DbGate could automatically detect and execute these kinds of queries in one go. To keep this review concise, I’ll send an anonymized example query by email rather than pasting it here.