Keyrockwormhole
    Updated 2024-01-18
    with chains_meta AS (
    -- wormhole chain id
    -- resource: https://docs.wormhole.com/wormhole/reference/constants
    SELECT 'solana' AS chain_name, '1' AS chain_id UNION
    SELECT 'ethereum' AS chain_name, '2' AS chain_id UNION
    SELECT 'terra' AS chain_name, '3' AS chain_id UNION
    SELECT 'bsc' AS chain_name, '4' AS chain_id UNION
    SELECT 'polygon' AS chain_name, '5' AS chain_id UNION
    SELECT 'avalanche' AS chain_name, '6' AS chain_id UNION
    SELECT 'oasis' AS chain_name, '7' AS chain_id UNION
    SELECT 'algorand' AS chain_name, '8' AS chain_id UNION
    SELECT 'aurora' AS chain_name, '9' AS chain_id UNION
    SELECT 'fantom' AS chain_name, '10' AS chain_id UNION
    SELECT 'karura' AS chain_name, '11' AS chain_id UNION
    SELECT 'acala' AS chain_name, '12' AS chain_id UNION
    SELECT 'klaytn' AS chain_name, '13' AS chain_id UNION
    SELECT 'celo' AS chain_name, '14' AS chain_id UNION
    SELECT 'near' AS chain_name, '15' AS chain_id UNION
    SELECT 'moonbeam' AS chain_name, '16' AS chain_id UNION
    SELECT 'neon' AS chain_name, '17' AS chain_id UNION
    SELECT 'terra2' AS chain_name, '18' AS chain_id UNION
    SELECT 'injective' AS chain_name, '19' AS chain_id UNION
    SELECT 'osmosis' AS chain_name, '20' AS chain_id UNION
    SELECT 'sui' AS chain_name, '21' AS chain_id UNION
    SELECT 'aptos' AS chain_name, '22' AS chain_id UNION
    SELECT 'arbitrum' AS chain_name, '23' AS chain_id UNION
    SELECT 'optimism' AS chain_name, '24' AS chain_id UNION
    SELECT 'gnosis' AS chain_name, '25' AS chain_id UNION
    SELECT 'pythnet' AS chain_name, '26' AS chain_id UNION
    SELECT 'xpla' AS chain_name, '28' AS chain_id UNION
    SELECT 'base' AS chain_name, '30' AS chain_id UNION
    SELECT 'sei' AS chain_name, '32' AS chain_id UNION
    SELECT 'rootstock' AS chain_name, '33' AS chain_id UNION
    SELECT 'cosmoshub' AS chain_name, '4000' AS chain_id UNION
    SELECT 'evmos' AS chain_name, '4001' AS chain_id UNION
    SELECT 'kujira' AS chain_name, '4002' AS chain_id UNION