DBeaver and Spatialite

spatialite.sql

-- load the extension (usually mod_spatialite)
select load_extension("/opt/homebrew/lib/mod_spatialite.dylib");

-- display the current version to prove it's loaded
select spatialite_version();

-- Transform the geometry to st_astext in your queries
select st_astext(GEOM) as geom from not_enabled_airspace;

-- or as binary
SELECT GLOBAL_ID, st_asbinary(GEOM) as geom from airspace;

-- Rigt click on one row -> View/Format -> Set "geom" transform -> Geometry