dbeaver.DataSources_connection - V

CREATE View dbeaver.DataSources_connection
As
Select
    --
    j1.*
  , j2.*
  , connection_key  = j3.[Key]
  , connection_json = j3.Value
  , j4.*
From
    dbeaver.DataSources As j1
    Cross Apply
    OpenJson ( j1.BulkColumn )
    With
    (
        connections NVarchar ( Max ) N'$.connections' As Json
    )                   As j2
    Cross Apply OpenJson ( j2.connections ) As j3
    Cross Apply
    OpenJson ( j3.Value )
    With
    (
        connection_provider NVarchar ( 100 ) N'$.provider'
      , connection_driver NVarchar ( 100 ) N'$.driver'
      , conection_name NVarchar ( 100 ) N'$.name'
    ) As j4