Query to combine OSMaxx roads and railways (suitable as QGIS virtual layer query)

OSMaxx_roads_and_railways.sql

SELECT
  "osm_id", "lastchange", "geomtype", geometry, "type", "name", "label", "tags",
  'highway' as "super_type",
  "aggtype",
  "bridge",
  NULL as "frequency",
  "oneway",
  "ref",
  'operational' as "status",
  "tunnel",
  NULL as "voltage",
  "z_order"
FROM road_l

UNION

SELECT
  "osm_id", "lastchange", "geomtype", geometry, "type", "name", "label", "tags",
  'railway' as "super_type",
  "aggtype",
  "bridge",
  "frequency",
  NULL as "oneway",
  NULL as "ref",
  'operational' as "status",
  "tunnel",
  "voltage",
  "z_order"
FROM railway_l

UNION

SELECT
  "osm_id", "lastchange", "geomtype", geometry, "sub_type" as "type", "name", "label", "tags",
  "type" as "super_type",
  NULL as "aggtype",
  NULL as "bridge",
  NULL as "frequency",
  NULL as "oneway",
  "ref",
  "status",
  NULL as "tunnel",
  NULL as "voltage",
  "z_order"
FROM nonop_l