Squawk is a free command line based tool and library for running SQL queries against structured/semi-structured static files. (e.g. Apache logs, tcpdump output, csv files).
The purpose is Squawk is to make querying for data in log files or other structured files easier. Everything that Squawk does can be done by combining various unix tools, but Squawk makes it ever easier to express more complex relationships.
Squawk is in no way a database or meant to be used as such. It`s merely a reporting tool.
Squawk can be used from the command line for ad-hoc queries, and it can also be used as a library as a part of a more in-depth reporting tool.
Supported SQL features:
· Aggregates: count, min, max, avg, sum
· GROUP BY
· ORDER BY (single column)
· LIMIT
· OFFSET
· WHERE
· Column aliases
· Subqueries in FROM
Requirements:
· Python 2.5 or later
· Pyparsing