athenaSQL
athenaSQL is Athena SQL query builder, inspired by sparkSQL. It borrow some sparkSQL's concept sparkSQL.
It was initially designed to eliminate the need for hard-coding SQL queries as strings within Python scripts and as an alternative to any bespoke SQL query templating. However, it offers the flexibility to be used in various ways as needed.
Quickstart
Installing athenaSQL
$ pip install athenaSQL
Usage
Using athenaSQL is stright forward. First we create a table abstraction class then building a query is just calling chain methods on top of it.
from athenaSQL import Athena
# creating athena table instance from database
table = Athena('database_name').table('table_name')
# creating athena table instance from database
query = table.select()
query.show_query()
SELECT
*
FROM "database_name"."table_name"
Metadata
Release files for athenaSql 0.1.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| athenasql-0.1.1.tar.gz | 20.9 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| athenasql-0.1.1-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 51.4 kB
Release files / athenasql-0.1.1.tar.gz
| Download URL | athenasql-0.1.1.tar.gz |
|---|---|
| Size | 20.9 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
72df75f4fd83211339fdb04c7e2b2bf2920c841cd3798259340921a7066c6cc1
|
|
BLAKE2b-256 checksum How to use checksums |
3cb07641cc3536437aee6570ff5a938ee33b14ef90b3b04541e1408e589fdad7
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/1.8.4 CPython/3.9.20 Linux/6.5.0-1025-azure
|
Release files / athenasql-0.1.1-py3-none-any.whl
| Download URL | athenasql-0.1.1-py3-none-any.whl |
|---|---|
| Size | 30.5 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
6e158f0001c3563c1047547714a48718c351f1d84a45e60aa8c1604ad28bf57a
|
|
BLAKE2b-256 checksum How to use checksums |
7a7f0e6936d2166faf8add9aa76fe204bcefb549b8ea23996afa3fa1b90c83b4
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/1.8.4 CPython/3.9.20 Linux/6.5.0-1025-azure
|