Query editor
WITHnftfi as (SELECT'nftfi' as loan_type,contract_address,adminFee as admin_fee,amountPaidToLender as repaid_amount,borrower,lender,loanERC20Denomination as loan_token_address,CAST(loanId as VARCHAR) as loan_id,loanPrincipalAmount as loan_amount,nftCollateralContract as collateral_contract,CAST(nftCollateralId as VARCHAR) as collateral_id,evt_block_number,evt_block_time,evt_index,evt_tx_hashFROMnftfi_ethereum.NFTfi_evt_LoanRepaid),directloanfixedcollectionoffer_v2_3_loan_repaid as (SELECT'DirectLoanFixedCollectionOffer_v2.3' as loan_type,contract_address,adminFee as admin_fee,amountPaidToLender as repaid_amount,borrower,lender,loanERC20Denomination as loan_token_address,CAST(loanId as VARCHAR) as loan_id,loanPrincipalAmount as loan_amount,nftCollateralContract as collateral_contract,CAST(nftCollateralId as VARCHAR) as collateral_id,evt_block_number,evt_block_time,evt_index,evt_tx_hashFROMnftfi_ethereum.DirectLoanFixedCollectionOffer_v2_3_evt_LoanRepaid),directloanfixedoffer_v2_3_loan_repaid as (SELECT'DirectLoanFixedOffer_v2.3' as loan_type,contract_address,adminFee as admin_fee,amountPaidToLender as repaid_amount,borrower,lender,loanERC20Denomination as loan_token_address,CAST(loanId as VARCHAR) as loan_id,loanPrincipalAmount as loan_amount,nftCollateralContract as collateral_contract,CAST(nftCollateralId as VARCHAR) as collateral_id,evt_block_number,