- 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.