Stanley Clarke, surely one of the most respected of all bass player, regularly plays a piccolo bass.
But a much more interesting exponent is Foley, who played with Miles Davis for a couple of years before Miles died.
Miles Davis said that Foley was the guitarist he had always been looking for.
I'm looking forward to seeing Marcus Miller later on this year reprising TUTU the Miles Davis album that totally astonished me when it was released. I'm hoping that Marcus uses the later incarnations of the Miles Davis band when he is performing it in London later on this year. I really really hope that includes Foley.
Anyone interested in this guy should Google him, he has a fascinating web site, with incredibly interesting interviews.
Finally, both Stanley and Foley had totally different approaches to playing the piccolo bass. Stanley I believe used his trade mark Short Scale Alembic tuned an Octave up.
Foley seems to use a headless short scale bass, with guitar strings, with loads of overdrive, and plays it like a regular guitar player would. I assume he enjoyed the longer scale length, and the wider string spacing, both are monster players and soloists.
I would suggest ignoring the word BASS, and just enjoy 2 incredibly talented and inventive musicians doing their individual thing.