Query everything in one place.

Combine queries between any JDBC compatible database or JSON/CSV/HTML data sources

Click here to try this code in a live environment.

Query_web( REST/CSV/HTML )

To query JSON/CSV/HTML based tables use query_web and BabelDB will automatically detect the format and return a table:

BabelDB Web Querying

query_web takes the following arguments:

HTTPHTTP endpoint with data
JQ Path (Optional)JQ Path Expression
ColumnTypes (Optional)A json struct that specifies the key names and value types contained within the JSON file
e.g. ``{key1: 'INTEGER', key2: 'VARCHAR'}`` - If not specified these will be guessed.

Query_db(db,) - join data from different databases

Add a mysql / postgresql connection and query them. Notice the SQL queries can be wrapped in parentheses (), Quotes also work but parentheses allow SQL highlighting to work better in most editors.

Comparing the U.S. Unemployment rate to U.S. National Home Price Index:

BabelDB Querying Multiple Databases

Query_data( hardcoded JSON/CSV )

BabelDB Querying CSV/JSON Data


Why do this?

TimeStored make tools for data analysts and SQL users:

  • qStudio is an SQL IDE for data analysts
  • PulseUI is a low-code tool for developing real-time internal applications fast.

BabelJDBC allows PulseUI to combine queries from any data source in a clean way without clicking and dragging UI elements. We are particularly proud that it just is SQL with special functions added in.

Hows does it work?

query_ queries cause temporary tables to be created and the function call is replaced with that table name. Simplified example: select date,txt from query_web(''); becomes:

	INSERT INTO TABLE temp.price VALUES( ......);
	INSERT INTO TABLE temp.price VALUES( ......);

	select date,txt from temp.price;

Limitations / TODO

  • Babel only supports limited simple column types. Would be nice to add arrays etc.
  • Babel uses H2 version 1.4.200 as SQL engine, Pluggable option would allow user to choose.

Why Babel?

From The Hitchhiker's Guide to the Galaxy , The Babel fish is a small, bright yellow fish, which can be placed in someone's ear in order for them to be able to hear any language translated into their first language. Ford Prefect puts one in Arthur Dent's ear at the beginning of the story so that he can hear the Vogon speech.

BabelJDBC allows combining queries between any JDBC compatible database.

BabelDB Fish

Huge credit and thanks goes to: