SQL Tutorial

This functionality requires an experimental sql plugin. Read More

Frictionless supports reading and writing SQL databases.

CLI

pip install frictionless[sql]

pip install 'frictionless[sql]' # for zsh shell

Reading Data

You can read SQL database:

Python

from pprint import pprint

from frictionless import Package

package = Package.from_sql('postgresql://database')

pprint(package)

for resource in package.resources:

pprint(resource.read_rows())

SQLite

Here is a example of reading a table from a SQLite database using basepath:

Python

from frictionless import Resource

from frictionless.plugins.sql import SqlDialect

dialect = SqlDialect(table="test_table", basepath='data')

with Resource(path="sqlite:///sqlite.db", dialect=dialect) as resource:

print(resource.read_rows())

Writing Data

[NOTE] Timezone information is ignored for datetime and time types.

You can write SQL databases:

Python

from frictionless import Package

package = Package('path/to/datapackage.json')

package.to_sql('postgresql://database')

Configuring Data

There is a dialect to configure how Frictionless read and write files in this format. For example:

from frictionless import Resource

from frictionless.plugins.sql import SqlDialect

dialect = SqlDialect(table='table', order_by='field', where='field > 20')

resource = Resource('postgresql://database', dialect=dialect)

References:

• SQL Dialect