-- Avalanche

SELECT borrower AS user, 'avalanche' AS chain FROM avalanche.defi.ez_lending_borrows WHERE platform ILIKE 'aave%'

UNION ALL

SELECT depositor AS user, 'avalanche' AS chain FROM avalanche.defi.ez_lending_deposits WHERE platform ILIKE 'aave%'

UNION ALL

SELECT depositor AS user, 'avalanche' AS chain FROM avalanche.defi.ez_lending_withdraws WHERE platform ILIKE 'aave%'

UNION ALL

SELECT payer AS user, 'avalanche' AS chain FROM avalanche.defi.ez_lending_repayments WHERE platform ILIKE 'aave%'

UNION ALL

-- Base

SELECT borrower AS user, 'base' AS chain FROM base.defi.ez_lending_borrows WHERE platform ILIKE 'aave%'

UNION ALL

SELECT depositor AS user, 'base' AS chain FROM base.defi.ez_lending_deposits WHERE platform ILIKE 'aave%'

UNION ALL

SELECT depositor AS user, 'base' AS chain FROM base.defi.ez_lending_withdraws WHERE platform ILIKE 'aave%'

UNION ALL

SELECT payer AS user, 'base' AS chain FROM base.defi.ez_lending_repayments WHERE platform ILIKE 'aave%'

UNION ALL

-- Ethereum

SELECT borrower AS user, 'ethereum' AS chain FROM ethereum.defi.ez_lending_borrows WHERE platform ILIKE 'aave%'

UNION ALL

SELECT depositor AS user, 'ethereum' AS chain FROM ethereum.defi.ez_lending_deposits WHERE platform ILIKE 'aave%'

UNION ALL

SELECT depositor AS user, 'ethereum' AS chain FROM ethereum.defi.ez_lending_withdraws WHERE platform ILIKE 'aave%'

UNION ALL

SELECT payer AS user, 'ethereum' AS chain FROM ethereum.defi.ez_lending_repayments WHERE platform ILIKE 'aave%'

UNION ALL

-- Polygon

SELECT borrower AS user, 'polygon' AS chain FROM polygon.defi.ez_lending_borrows WHERE platform ILIKE 'aave%'