It depends on what the database is being used for. There isn't a single "Bitcoin use case". Are you talking about UTXO set storage? An index? A wallet? It all depends on what you are actually planning on using the database for.

For example, Bitcoin Core currently uses LevelDB for the UTXO set and all indexes (block index, transaction index, block filter index). Berkeley DB and SQLite (in 0.21 for descriptor wallets) are used for the wallet.