Skip to main content

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)

Source distribution for athenaSql 0.1.1
File Size Uploaded
athenasql-0.1.1.tar.gz 20.9 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for athenaSql 0.1.1
File Interpreter ABI Platform
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
Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page