Skip to main content

BQX

Build Status Coverage Status

Generate sophisticated query for Google BigQuery in simple way.

ARCHIVED

This project is archived and no longer maintained.

What is BQX?

BQX is a minimal query generator for Google BigQuery. It’s mainly intended for being used by data analysts / scientists who want to analyze big data.

BQX fires its power especially on making LONG and NESTED query. BigQuery doesn’t accept two or more queries at once so user has to make views or make terribly nested query. BQX’s features help you make long query preserving high readability. See example for its features and usage.

Requirements

  • Python 3.4 ~

Installing

pip install bqx

Example

>>> from bqx.query import Query as Q
>>> from bqx.parts import Table as T, Column as C
>>> from bqx.func import SUM
>>>
>>> shakespeare = T('publicdata:samples.shakespeare')
>>> word = C('word')
>>> q = Q().SELECT(word).FROM(shakespeare).LIMIT(10)
>>> print(q.getq())
SELECT word
FROM publicdata:samples.shakespeare
LIMIT 10

See example directory for more detailed examples.

License

This library is BSD-licensed.

Q&A

How can I use it?

Running example on REPL is good for getting started, and we suggest you to use BQX with front-ends like pandas for next step.

Is it only for BigQuery? How about MySQL or else?

It aims to generate query excecuted on BigQuery but it might be applied to other SQL environments because difference between plain SQL and BigQuery is small.

We are using some compute engines which can process SQL (and dialects) like BigQuery, Hadoop and Spark. So in near future, adding other SQL dialect is planned.

Why some functions are UPPERCASE?

The first reason is for avoiding collision with Python’s reserved words. The another reason is for SQL’s UPPERCASE manners.

Is it ready to use?

We hope it’s so. All main clauses are implemented from v0.2.0, but not fully tested by hand yet.

Where are documentations?

We’re sorry but documentation is not available right now. It will be published on ReadTheDocs.org soon. Stay tuned.

Metadata

Release files for bqx 0.4.2

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for bqx 0.4.2
File Size Uploaded Provenance Actions
bqx-0.4.2.tar.gz 18.0 kB Without provenance Details for bqx-0.4.2.tar.gz

Release files / bqx-0.4.2.tar.gz

Download URL bqx-0.4.2.tar.gz
Size 18.0 kB
Tags Source
SHA-256 checksum
How to use checksums
cd2fd96e4dbb18907ee024a8d24a79c50a211f1f9ea59bddf6f1c362ea052acb
BLAKE2b-256 checksum
How to use checksums
7878f43b194eec1c34ba323eafff886165cb5287027697370f29effee2afe592
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/4.0.2 CPython/3.11.1

Security for bqx 0.4.2

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

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