Repository: heavyai/ibis-heavyai (language: python)

Issue:
Add __version__ to ibis-omniscidb
Currently, the project doesn't implement `__version__. 
According to setuptools-scm (used by ibis-omniscidb), it can be implemented using:

```
from importlib.metadata import version, PackageNotFoundError

try:
    __version__ = version("package-name")
except PackageNotFoundError:
    # package is not installed
    pass
```

https://pypi.org/project/setuptools-scm/
Fix displayed version
After installing the package using mamba, the version of the package is incorrect:

```bash
$ pip list | grep omnisci
ibis-omniscidb        0.0.0
pyomnisci             0.0.0
pyomniscidb           5.7.0
```

```
$ python
>>> import ibis_omniscidb
>>> ibis_omniscidb.__version__
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
AttributeError: module 'ibis_omniscidb' has no attribute '__version__'
>>> import pyomnisci
>>> pyomnisci.__version__
'0.0.0'
```


Discussion / hints:

Fix patch:
diff --git a/ibis_omniscidb/__init__.py b/ibis_omniscidb/__init__.py
index 2e5843c..46fef84 100644
--- a/ibis_omniscidb/__init__.py
+++ b/ibis_omniscidb/__init__.py
@@ -2,6 +2,7 @@
 from __future__ import annotations
 
 import warnings
+from importlib.metadata import PackageNotFoundError, version
 from typing import Optional, Union
 
 import ibis.common.exceptions as com
@@ -24,12 +25,18 @@
 from .compiler import OmniSciDBCompiler
 from .udf import OmniSciDBUDF
 
+try:
+    __version__ = version("ibis_omniscidb")
+except PackageNotFoundError:
+    __version__ = ""
+
+
 try:
     from cudf import DataFrame as GPUDataFrame
 except (ImportError, OSError):
     GPUDataFrame = None
 
-__all__ = ('Backend',)
+__all__ = ('Backend', "__version__")
 
 
 class Backend(BaseSQLBackend):


Test patch:
diff --git a/ibis_omniscidb/tests/test_client.py b/ibis_omniscidb/tests/test_client.py
index 28699cf..a27c24b 100644
--- a/ibis_omniscidb/tests/test_client.py
+++ b/ibis_omniscidb/tests/test_client.py
@@ -347,3 +347,7 @@ def test_current_database(con):
 def test_list_databases(con):
     assert 'ibis_testing' in con.list_databases()
     assert 'ibis_testing' in con.list_databases(like='ibis.*')
+
+
+def test_version():
+    assert ibis_omniscidb.__version__