SQL with Python in the middle. SPyQL is a query language that combines the simplicity and structure of SQL with the power and readability of Python. SPyQL offers a command-line interface that allows running SPyQL queries on top of text data (e.g. CSV, JSON). Data can come from files but also from data streams, such as as Kafka, or from databases such as PostgreSQL. Basically, data can come from any command that outputs text :-). More, data can be generated by a Python expression! And since SPyQL also writes to different formats, it allows to easily convert between data formats.

Features

  • SQL provides the structure of the query
  • SPyQL is fast and memory efficient
  • SPyQL offers a command-line interface that allows running SPyQL queries on top of text data
  • SPyQL also writes to different formats, it allows to easily convert between data formats
  • SPyQL is also available as a Python module
  • Natural support for lists, sets, dictionaries, objects, etc

Project Samples

Project Activity

See All Activity >

Categories

JSON

License

MIT License

Follow SPyQL

SPyQL Web Site

Other Useful Business Software
The full-stack observability platform that protects your dataLayer, tags and conversion data Icon
The full-stack observability platform that protects your dataLayer, tags and conversion data

Stop losing revenue to bad data today. and protect your marketing data with Code-Cube.io.

Code-Cube.io detects issues instantly, alerts you in real time and helps you resolve them fast. No manual QA. No unreliable data. Just data you can trust and act on.
Learn More
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of SPyQL!

Additional Project Details

Programming Language

Python

Related Categories

Python JSON Software

Registered

2023-10-17