Can you buy it?
Yes.
Can you possess it?
No.
Werid, eh?
A store can sell you what is obviously a device intended for the consumption of a controlled substance, but you can’t possess paraphernalia.
It’s a distinction without a difference to argue that it can be used for a non-controlled substance. That’s not the issue. The only question is can it be used to ingest a controlled substance.
If it can be used to consume a controlled substance it is a narcotic implement, also known as drug paraphernalia – this is left up to the police’s judgement.