SELECT 'Hop' AS bridge, PARSE_JSON('["Arbitrum", "Base", "Ethereum", "Gnosis", "Linea", "Optimism", "Polygon", "Polygon zkEVM"]') AS lifi_chains UNION ALL

SELECT 'Celer cBridge' AS bridge, PARSE_JSON('["Arbitrum", "Avalanche", "BSC", "Base", "Blast", "Ethereum", "Gravity", "Linea", "Metis", "Optimism", "Polygon", "Polygon zkEVM", "Scroll", "zkSync"]') AS lifi_chains UNION ALL

SELECT 'Optimism Gateway' AS bridge, PARSE_JSON('["Ethereum", "Optimism"]') AS lifi_chains UNION ALL

SELECT 'Arbitrum Bridge' AS bridge, PARSE_JSON('["Arbitrum", "Ethereum"]') AS lifi_chains UNION ALL

SELECT 'Across' AS bridge, PARSE_JSON('["Arbitrum", "Base", "Blast", "Ethereum", "Ink", "Lens", "Linea", "Lisk", "Mode", "Optimism", "Polygon", "Scroll", "Soneium", "Unichain", "World Chain", "zkSync"]') AS lifi_chains UNION ALL

SELECT 'Gnosis Bridge' AS bridge, PARSE_JSON('["Ethereum", "Gnosis"]') AS lifi_chains UNION ALL

SELECT 'Omni Bridge' AS bridge, PARSE_JSON('["Ethereum", "Gnosis"]') AS lifi_chains UNION ALL

SELECT 'Circle CCTP' AS bridge, PARSE_JSON('["Arbitrum", "Avalanche", "Base", "Ethereum", "Optimism", "Polygon"]') AS lifi_chains UNION ALL

SELECT 'Allbridge Core' AS bridge, PARSE_JSON('["Arbitrum", "Avalanche", "BSC", "Base", "Celo", "Ethereum", "Optimism", "Polygon"]') AS lifi_chains UNION ALL

SELECT 'CelerIM' AS bridge, PARSE_JSON('["Arbitrum", "Aurora", "Avalanche", "BSC", "Ethereum", "Fantom", "Moonriver", "Optimism", "Polygon", "Polygon zkEVM", "zkSync"]') AS lifi_chains UNION ALL

SELECT 'Thorswap' AS bridge, PARSE_JSON('["Avalanche", "BSC", "Ethereum"]') AS lifi_chains UNION ALL

SELECT 'Symbiosis' AS bridge, PARSE_JSON('["Abstract", "Arbitrum", "Avalanche", "BSC", "Base", "Berachain", "Blast", "Boba", "Cronos", "Ethereum", "Fraxtal", "Gnosis", "Gravity", "Linea", "Mantle", "Metis", "Mode", "Optimism", "Polygon", "Polygon zkEVM", "Rootstock", "Scroll", "Sei", "Soneium", "Sonic", "Taiko", "Unichain", "zkSync"]') AS lifi_chains UNION ALL

SELECT 'SquidRouter' AS bridge, PARSE_JSON('["Arbitrum", "Avalanche", "BSC", "Base", "Blast", "Celo", "Ethereum", "Fantom", "Fraxtal", "Immutable zkEVM", "Linea", "Mantle", "Moonbeam", "Optimism", "Polygon", "Scroll"]') AS lifi_chains UNION ALL

SELECT 'StargateV2 (Fast mode)' AS bridge, PARSE_JSON('["Abstract", "Arbitrum", "Aurora", "Avalanche", "BSC", "Base", "Berachain", "Ethereum", "FUSE", "Gnosis", "Gravity", "Ink", "Kaia", "Linea", "Mantle", "Metis", "Optimism", "Polygon", "Rootstock", "Scroll", "Sei", "Soneium", "Sonic", "Superposition", "Taiko"]') AS lifi_chains UNION ALL

SELECT 'Mayan (Swift)' AS bridge, PARSE_JSON('["Arbitrum", "Avalanche", "BSC", "Base", "Ethereum", "Optimism", "Polygon", "Unichain"]') AS lifi_chains UNION ALL

SELECT 'Mayan (Wormhole)' AS bridge, PARSE_JSON('["Ethereum"]') AS lifi_chains UNION ALL

SELECT 'Mayan (MCTP)' AS bridge, PARSE_JSON('["Arbitrum", "Avalanche", "BSC", "Base", "Ethereum", "Optimism", "Polygon", "Unichain"]') AS lifi_chains UNION ALL

SELECT 'StargateV2 (Economy mode)' AS bridge, PARSE_JSON('["Abstract", "Arbitrum", "Aurora", "Avalanche", "BSC", "Base", "Berachain", "Ethereum", "FUSE", "Gnosis", "Gravity", "Ink", "Kaia", "Linea", "Mantle", "Metis", "Optimism", "Polygon", "Rootstock", "Scroll", "Sei", "Soneium", "Sonic", "Superposition", "Taiko"]') AS lifi_chains UNION ALL

SELECT 'Relay' AS bridge, PARSE_JSON('["Abstract", "Arbitrum", "Avalanche", "BSC", "Base", "Berachain", "Blast", "Boba", "Corn", "Ethereum", "Gnosis", "Gravity", "Ink", "Linea", "Lisk", "Mantle", "Mode", "Optimism", "Polygon", "Polygon zkEVM", "Scroll", "Sei", "Soneium", "Sonic", "Superposition", "Swellchain", "Taiko", "Unichain", "World Chain", "zkSync"]') AS lifi_chains UNION ALL

SELECT 'Polygon PoS Bridge' AS bridge, PARSE_JSON('["Ethereum", "Polygon"]') AS lifi_chains UNION ALL

SELECT 'glacis' AS bridge, PARSE_JSON('["Arbitrum", "Avalanche", "BSC", "Base", "Ethereum", "Linea", "Mode", "Optimism", "Polygon", "Scroll"]') AS lifi_chains

),

flattened_lifi AS (

SELECT

bridge,

UPPER(chains.value::string) AS chain_name -- Normalize case here

FROM

lifi_bridges,

LATERAL FLATTEN(input => lifi_chains) AS chains

),

exploded_data AS (

SELECT

bridge_name,