How to extract all info for a public address from a local full node's db? I recently started running bitcoind on a local Debian host, and I am still learning how to use the information in the local copy of the bitcoin blockchain.
I would like to extract all the information for one or more public bitcoin addresses currently available in the full node locally 1.  EDIT 2: I want to do this both from the bash command line and programmatically.  (IOW: no GUI-based tools, please.)
I recently learned that, contrary to my initial expectation, bitcoin core is not suitable for performing this sort of query.
Therefore, I went back to Google, but I've come up empty 3.  Hence I'm posting my question here.
Specifically, I would like to know

what software (preferably in the form of one or more Debian packages) would I need to install on the local full node that would enable me to extract all the information for one or more public bitcoin addresses currently available in the full node locally;
how exactly would I use this software to perform such queries.


1 I want to do this without reference to any specific wallet.  Having to add this requirement feels extremely weird to me (like having to add the requirement that answers to my question should work seven days a week).  This is a clear sign to me that there is still at least one pretty gigantic gap and/or confusion in my understanding of bitcoin, because I don't understand why a wallet should be even relevant to the kind of query I want to do.  I would have thought that a wallet would be, at most, an optional piece of information to modify the query, not an essential input for it.  But the fact is that I have not been able to find any way to interrogate the full node's database for specific addresses that does not require specifying a wallet.  This is just mind-boggling to me.
2 I apologize for not mentioning this critical requirement in my original post.  That was a major oversight on my part!
3 I am beginning to realize that the queries I want to perform on a full node's database (and without reference to a wallet) is something practically no one cares to do, and therefore it is hard to find tools for doing them.  Again, this strikes me as a bit weird, and feeds my growing suspicion that I am totally missing the point about bitcoin, blockchains, full nodes, etc.
Why this is hard
Bitcoin Core is chiefly a tool to synchronize with the current state of the network and to enforce the consensus rules with a self-owned piece of hardware. Beside being on the same page regarding the rules, this requires the node only to keep track of the ledger, the Unspent Transaction Output (UTXO) set. Bitcoin transactions need to be processed only once to that end.
The blockchain being now over 330 GiB, some people are actually choosing to run pruned nodes (that discard old blockchain data after processing it to calculate the UTXO set). Keeping additional indexes around with dozens of GiB in size is a special interest most users don't seem to care for.
In fact, Bitcoin Core does not feature a full address index out of the box. Originally maybe, because address reuse is considered a bad practice, later because other projects offer this, leaving Bitcoin Core developers feeling that they could focus on other things.
How you do it anyway
Bitcoin Core has an option to build a full transaction index -txindex (turning it on will require you to start over with synchronization and take about 30 GiB more space). This index is needed if you want to look up arbitrary transactions from the past. Other projects leverage this functionality and build additional indexing capability around it to offer Lightning Network support or Bitcoin explorers. I would recommend that you look into the Mempool Open Source Project or the Esplora Block Explorer. Either of these will allow you to run your own instance of a block explorer with APIs to look up blockchain data on basis of addresses. Note that the Esplora index will take about 1 TiB and apparently takes quite some time to build (H/T @Anonymous).