This release adds 3 notable features for engineering teams evaluating rollout.
✓ No known CVEs patched in this version
Topics
+13 more
Summary
AI summaryExport reconstructs spatial columns with dialect‑specific SQL, adds interactive map previews and navigation controls for geometry/geography data, and improves association analysis handling NATURAL JOIN/USING syntax.
Changes in this release
| Type | Severity | Summary | CVE |
|---|---|---|---|
| Feature | Low |
Adds spatial data preview with interactive map for geometry/geography values. Adds spatial data preview with interactive map for geometry/geography values. Source: llm_adapter@2026-07-16 Confidence: high |
— |
| Feature | Low |
Adds support for points, lines, polygons and their multi-/collection variants in spatial preview. Adds support for points, lines, polygons and their multi-/collection variants in spatial preview. Source: llm_adapter@2026-07-16 Confidence: high |
— |
| Feature | Low |
Adds coordinate system support for WGS84 (SRID 4326/8307) and EPSG:3857 Web Mercator in spatial preview. Adds coordinate system support for WGS84 (SRID 4326/8307) and EPSG:3857 Web Mercator in spatial preview. Source: llm_adapter@2026-07-16 Confidence: high |
— |
| Feature | Low |
Adds map navigation: drag to pan, mouse wheel to zoom, Shift+drag for box zoom in SQL Console. Adds map navigation: drag to pan, mouse wheel to zoom, Shift+drag for box zoom in SQL Console. Source: llm_adapter@2026-07-16 Confidence: high |
— |
| Feature | Low |
Adds high-contrast outline/halo for geometries and colored ring rendering for points in spatial preview. Adds high-contrast outline/halo for geometries and colored ring rendering for points in spatial preview. Source: llm_adapter@2026-07-16 Confidence: high |
— |
| Feature | Low |
Adds hover tooltip showing row data for geometries in SQL Console spatial preview. Adds hover tooltip showing row data for geometries in SQL Console spatial preview. Source: llm_adapter@2026-07-16 Confidence: low |
— |
| Feature | Low |
Adds legend with color‑by‑column, palette selection, text size adjustment, and free move/resize in SQL Console spatial preview. Adds legend with color‑by‑column, palette selection, text size adjustment, and free move/resize in SQL Console spatial preview. Source: llm_adapter@2026-07-16 Confidence: low |
— |
| Feature | Low |
Adds "Save as image" option to export current map view from spatial preview. Adds "Save as image" option to export current map view from spatial preview. Source: llm_adapter@2026-07-16 Confidence: low |
— |
| Feature | Low |
Enhances "Analyze SQL" to flag partially covered primary keys in proposed associations. Enhances "Analyze SQL" to flag partially covered primary keys in proposed associations. Source: llm_adapter@2026-07-16 Confidence: low |
— |
| Feature | Low |
Export reconstructs spatial column values using dialect‑specific SQL expressions, preserving type information. Export reconstructs spatial column values using dialect‑specific SQL expressions, preserving type information. Source: granite4.1:30b@2026-07-16-audit Confidence: low |
— |
| Feature | Low |
Hovering a geometry in SQL Console highlights it and displays the row’s data as a tooltip. Hovering a geometry in SQL Console highlights it and displays the row’s data as a tooltip. Source: granite4.1:30b@2026-07-16-audit Confidence: low |
— |
| Feature | Low |
Provides legend that colors geometries by column values, lets users pick palettes, adjust text size, and move/resize freely (SQL Console). Provides legend that colors geometries by column values, lets users pick palettes, adjust text size, and move/resize freely (SQL Console). Source: granite4.1:30b@2026-07-16-audit Confidence: low |
— |
| Feature | Low |
Adds "Save as image" to export the current map view as PNG/JPG/BMP/GIF or copy to clipboard (omits handles in export). Adds "Save as image" to export the current map view as PNG/JPG/BMP/GIF or copy to clipboard (omits handles in export). Source: granite4.1:30b@2026-07-16-audit Confidence: low |
— |
| Feature | Low |
Analyze SQL understands "NATURAL JOIN" and "JOIN ... USING (col)" syntax and proposes associations for them. Analyze SQL understands "NATURAL JOIN" and "JOIN ... USING (col)" syntax and proposes associations for them. Source: granite4.1:30b@2026-07-16-audit Confidence: low |
— |
| Bugfix | Medium |
Fixes AssociationProposer dropping column equality in self-joins. Fixes AssociationProposer dropping column equality in self-joins. Source: llm_adapter@2026-07-16 Confidence: low |
— |
Full changelog
- Export now reconstructs spatial (geometry/geography) column values with a
dialect-specific SQL expression instead of losing type information. - Spatial data preview: geometry/geography values are shown on an interactive map over
OpenStreetMap tiles - both in the Data Browser's cell preview and, for the SQL Console,
as a map overlay on the "Rows"/"Columns" result.- Supports points, lines, polygons and their multi-/collection variant.
- Coordinate systems: WGS84 (SRID 4326/8307) and EPSG:3857 "Web Mercator" (the projection
used by web maps / online portals). - Navigation: drag to pan, mouse wheel to zoom (in the SQL Console the point under the
cursor stays fixed), Shift+drag to zoom into a box. - Geometries are drawn with a high-contrast outline/halo so they stay visible over any
map tiles; points render as a colored ring with a white center. Hovering a geometry in
the SQL Console highlights it and shows the row's data as a tooltip. - Legend (SQL Console): color the geometries by the values of a chosen column, pick a
color palette, adjust the legend text size, and move/resize the legend freely. - "Save as image": save the current map as a PNG/JPG/BMP/GIF file or copy it to the
clipboard (the move/resize handles are omitted from the exported image).
- "Analyze SQL": proposed associations are now checked for partially covered primary keys.
If a proposal's join condition equates only some columns of a composite primary key on
table "A" or "B", that cell is flagged with a warning icon and a tooltip listing the
still-uncovered column(s). - "Analyze SQL": AssociationProposer now understands "NATURAL JOIN" and "JOIN ... USING
(col)" syntax and proposes associations for them, instead of silently ignoring those
joins. - Fixed: AssociationProposer could silently drop a column equality from a proposed join
condition when the same table appeared twice in a query under different aliases
(self-join), because equations from different aliases were incorrectly treated as
duplicates.
Weekly OSS security release digest.
The CVE patches and breaking changes that affected production tools this week. One email, every Sunday.
No spam, unsubscribe anytime.
Share this release
About Wisser/Jailer
All releases →Related context
Related tools
Beta — feedback welcome: [email protected]