cardano-db-sync query example to interact with ada handles

query_ex_00.MD

-- ADA HANDLES FROM STAKE-KEY
SELECT convert_from(multi_asset.name, 'UTF8') FROM utxo_view JOIN stake_address ON stake_address.id = utxo_view.stake_address_id RIGHT JOIN tx_metadata ON utxo_view.tx_id = tx_metadata.tx_id RIGHT JOIN ma_tx_mint ON ma_tx_mint.tx_id = tx_metadata.tx_id LEFT JOIN multi_asset ON ma_tx_mint.ident = multi_asset.id WHERE view = ? AND multi_asset.policy='\xf0ff48bbb7bbe9d59a40f1ce90e9e9d0ff5002ec48f232b49ca0fb9a';

(test skey on preview: 'stake_test1urc63cmezfacz9vrqu867axmqrvgp4zsyllxzud3k6danjsn0dn70')

 -- w/ naming shortened -- 
SELECT convert_from(ma.name, 'UTF8') FROM utxo_view uv JOIN stake_address sa ON sa.id = uv.stake_address_id RIGHT JOIN tx_metadata txm ON uv.tx_id = txm.tx_id RIGHT JOIN ma_tx_mint ON ma_tx_mint.tx_id = txm.tx_id LEFT JOIN multi_asset ma ON ma_tx_mint.ident = ma.id WHERE view = ? AND ma.policy='\xf0ff48bbb7bbe9d59a40f1ce90e9e9d0ff5002ec48f232b49ca0fb9a';

-- ADDR FROM ADA HANDLE
select address from multi_asset ma RIGHT JOIN ma_tx_mint mtxm on mtxm.ident = ma.id RIGHT JOIN utxo_view uv on uv.tx_id = mtxm.tx_id  where ma.name = ?;

(test encoded multi_asset.name on preview: \x6a616d6573)

  -- w/ LIMIT 1 --
select address from multi_asset ma RIGHT JOIN ma_tx_mint mtxm on mtxm.ident = ma.id RIGHT JOIN utxo_view uv on uv.tx_id = mtxm.tx_id  where ma.name = ? LIMIT 1;