universal-sql-builder 0.0.3

create sql query with the help of sql builder magic function help to make automatic sql query its help in build sql query string for Microsoft SQL, MySql, SqlLite, PostgreSQL, ORACLE, Apache Hive, Django, FLASK, HBASE and Apache Spark etc.

Universal SQL Builder

SQL framework ORM independent, it helps you build sql query in python
What ever you using Hive, HBase, Spark* SQL, Django & FLASK etc so you can gernate simple SQL query
Its return raw sql query string this can be use in any Framework

Installation

Clone or Download all file in your lib(any folder) and see in the example.py

Select

UniversalSqlBuilder.table("employee").select("id,name").select(",department").get()

Where

You can use key and value based parameters : where("city=", "ABC")
Or you can use raw where query : where("col=(select id from users)")
UniversalSqlBuilder.table("employee").select("id,name").select(",department").where("ram=(select id from users)").where("city=", "delhi").get()

OrWhere and WhereBetween

If you want data according min and max use :
whereBetween("age",[200,300])  UniversalSqlBuilder.table("employee").select("id,name").whereBetween("age",[200,300]).get()
Using OR with where :
UniversalSqlBuilder.table("employee").select("id,name").orWhere("seller=",'100').get()

GroupBy, OrderBy amd Limit

Use of group by : groupBy("name")

UniversalSqlBuilder.table("employee").select("id,name").groupBy("name").get()

Use order by : orderBy("ID","desc") 

UniversalSqlBuilder.table("employee").select("id,name").orderBy("ID","desc").get()

use with limit : imit(10,20)

UniversalSqlBuilder.table("employee").select("id,name").limit(10,20).get()

Join ('FULL OUTER', 'INNER', 'LEFT', 'RIGHT', 'JOIN')

Default : join("users","users.id=employee.emp_id")

FULL OUTER : join("users","users.id=employee.emp_id","FULL OUTER")

INNER : join("users","users.id=employee.emp_id","INNER")

LEFT : join("users","users.id=employee.emp_id","LEFT")

RIGHT : join("users","users.id=employee.emp_id","RIGHT")

JOIN : join("users","users.id=employee.emp_id","JOIN")

Having & OrHaving

Using OR with Having :
UniversalSqlBuilder.table("employee").select("id,name").orHaving("seller=",'100').get()

You can use key and value based parameters : having("city=", "ABC")
Or you can use raw where query : having("col=(select id from users)")

UniversalSqlBuilder.table("employee").select("id,name").select(",department").having("id=(select id from users)").having("city=", "delhi").get()