JsonSQL4J

Generate SQL queries from JSON strings

License	MIT License
Categories	JSON Data
GroupId	io.github.eaxdev
ArtifactId	jsonsql4j
Last Version	0.0.3
Release Date	Aug 29, 2020
Type	pom.sha512
Description	JsonSQL4J Generate SQL queries from JSON strings
Project URL	https://github.com/eaxdev/JsonSQL4J
Project Organization	com.github.eaxdev
Source Code Management	https://github.com/eaxdev/JsonSQL4J

Download jsonsql4j

Filename	Size
jsonsql4j-0.0.3.pom
jsonsql4j-0.0.3-sources.jar	16 KB
jsonsql4j-0.0.3-javadoc.jar	112 KB

Dependencies

compile (1)

Group / Artifact	Type	Version
com.fasterxml.jackson.core : jackson-databind	jar	2.10.1

runtime (1)

Group / Artifact	Type	Version
org.projectlombok : lombok	jar	1.18.10

Project Modules

There are no modules declared in this project.

JsonSQL4J

This library for mapping JSON style query objects to SQL queries

Get it!

Maven

You can use following Maven dependency:

<dependency>
  <groupId>io.github.eaxdev</groupId>
  <artifactId>jsonsql4j</artifactId>
  <version>0.0.2</version>
</dependency>

Gradle

implementation 'io.github.eaxdev:jsonsql4j:0.0.2'

Also, you can use GitHub Packages.

Use it!

Given JSON:

{
  "fields": [
    {"column": "field1"},
    {"column": "field2", "alias": "test"}
  ],
  "from": [
    {"table": "table1", "schema": "schema"}
  ],
  "where": {
    "or": [
      { "eq": {"fieldName": "field3", "value": "5"} },
      { "eq": {"fieldName": "field4", "value": "3"} }
    ]
  }
}

use library:

Query selectQuery = new SelectQuery(jsonString);
String query = selectQuery.getQuery();
// query = SELECT field1, field2 AS test FROM schema.table1 WHERE (field3 = 5 OR field4 = 3)

You can find more examples here.

License

JsonSQL4J is open-source project, and distributed under the MIT license

Versions

Version
0.0.3 Aug 29, 2020
0.0.2 Jul 8, 2020
0.0.1 Jun 6, 2020