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
Error to trace to log to deploy. One click. No SSH. Icon
Error to trace to log to deploy. One click. No SSH.

Catch the cause before the pager goes off.

AppSignal links every error to the trace, the trace to the log, the log to the deploy that shipped it.
Free 30 days.
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