Agreeing that your best bet is a pickup that doesn’t need a preamp I had a thought. This will no doubt cause obsessive hand wringing from the puritan MBOL quarter but the most simple, foolproof pickup I’ve got is a Krivo magnetic.
Pros
1. No preamp required.
2. Goes much MUCH louder before feeding back.
3. Because of points 1&2 it’s easier to dial in a sound with whatever amp is convenient.
4. Dead simple to install.
5. Not prone to failure or wearing out.
6. Because of all the above becomes a great backup when it’s not your main pickup.
Cons
1. It won’t sound as “natural” as a piezo that works really well on your particular bass.
2. You’ll become the target of the MBOL cops.
Something you’ll hear (very shortly no doubt) is that a magnetic pickup sounds like a “giant P Bass”. This is not true of the Krivo. It is intentionally microphonic and grabs more a airy sound than any magnetic pickup I’ve heard. It might not sound as natural as a great piezo but it still sounds good. And it’s waaaaay better than a crappy sounding piezo.
It’s good to consider all options.
I liked the sound but not the form factor...
Your fear/antagonistic obsession with the MBOL Police is quaint... you will be assimilated.