> I wonder how Blockchain explorers deal with more complex scripts. For example on blockchain.com one can look up coins by putting an "address" into the search bar. But how would one look up coins that are not locked by a script that puts the coins under control of a certain key? Or a script that puts them under control of multiple keys?
I used to build blockchain explorers, and the answer is "they usually don't deal with it." Depending on how much resources the operator can devote to it, of couse. Some of the information simply cannot be pulled out because of cryptography, some require graph-like processing. Ethereum was/is a dream to work with compared to UTXO.