Skip to main content

EFILTER query language

Project description

# EFILTER Query Language

EFILTER is a general purpose query language designed to be embedded in Python applications and libraries. It supports SQL-like syntax to filter your application's data and provides a convenient way to directly search through the objects your applications manages.

A second use case for EFILTER is to translate queries from one query language to another, such as from SQL to OpenIOC and so on. A basic SQL-like syntax and a POC lisp implementation are included with the language, and others are relatively simple to add.

## Projects using EFILTER:

- [Rekall](

## Quick examples of integration.

from efilter import api
api.apply("5 + 5") # => 10

# Returns [{"name": "Alice"}, {"name": "Eve"}]
api.apply("SELECT name FROM users WHERE age > 10",
vars={"users": ({"age": 10, "name": "Bob"},
{"age": 20, "name": "Alice"},
{"age": 30, "name": "Eve"}))

### You can also filter custom objects:

# Step 1: have a custom class.

class MyUser(object):

# Step 2: Implement a protocol (like an interface).

from efilter.protocols import structured
implementations: {
structured.resolve: lambda user, key: getattr(user, key)

# Step 3: EFILTER can now use my class!
from efilter import api
api.apply("SELECT name FROM users WHERE age > 10 ORDER BY age",
vars={"users": [MyUser(...), MyUser(...)]})

### Don't have SQL injections.

EFILTER supports query templates, which can interpolate unescaped strings safely.

# Replacements are applied before the query is compiled.
search_term = dangerous_user_input["name"]
api.apply("SELECT * FROM users WHERE name = ?",
vars={"users": [...]},

# We also support keyword replacements.
api.apply("SELECT * FROM users WHERE name = {name}",
vars={"users": [...]},
replacements={"name": search_term})

### Basic IO is supported, including CSV data sets.

# Builtin IO functions need to be explicitly enabled.
api.apply("SELECT * FROM csv(users.csv) WHERE name = 'Bob'", allow_io=True)

## Language Reference

Work in progress.

## Protocol documentation

Work in progress.

## Example projects

Several sample projects are provided.

- examples/star_catalog: filters a large CSV file with nearby star systems
- examples/tagging: use a custom query format

## License and Copyright

Copyright 2015 Google Inc. All Rights Reserved

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at [](

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
See the License for the specific language governing permissions and
limitations under the License.

## Contributors

[Adam Sindelar](

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

efilter-1!1.3.tar.gz (71.2 kB view hashes)

Uploaded Source

Built Distribution

efilter-1!1.3-py2-none-any.whl (105.8 kB view hashes)

Uploaded Python 2

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page