Reading bz2-compressed tables from URL fails with c-engine in Python 2

[dhimmel]

In #14576, we consolidated compression code and introduced support for compressed URLs beyond just gzip. However, as described in #14576 (comment), the c-engine cannot read bz2-compressed URLs in python 2. This error is coming from parser.pyx#L615-L621. There may be potential to entirely bypass this offending code as it appears to duplicate the functionality of _get_handle.