python-sql

python-sql

Python Software Foundation
+
+

Related Products

  • DbVisualizer
    585 Ratings
    Visit Website
  • Retool
    593 Ratings
    Visit Website
  • Nutrient SDK
    111 Ratings
    Visit Website
  • Google Cloud BigQuery
    2,027 Ratings
    Visit Website
  • TinyPNG
    69 Ratings
    Visit Website
  • PDF Guru
    95,969 Ratings
    Visit Website
  • Cerberus FTP Server
    159 Ratings
    Visit Website
  • SurveyJS
    64 Ratings
    Visit Website
  • RaimaDB
    12 Ratings
    Visit Website
  • Okyline
    2 Ratings
    Visit Website

About

SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. It is written in Java and should run on any operating system that provides a Java Runtime Environment. Its main focus is on running SQL scripts (either interactively or as a batch) and export/import features. Graphical query building or more advanced DBA tasks are not the focus and are not planned. Powerful export command to write text files (aka "CSV"), XML, HTML or SQL (including BLOB data). All user tables can be exported into a directory with a single command. Export files can be compressed "on-the-fly". Powerful text, XML and spreadsheet import. A set of files (including compressed files) can be imported from a directory with a single command. Foreign key constraints are detected to insert the data in the correct order. Compare two database schemas for differences. The XML output can be transformed into the approriate SQL ALTER statements using XSLT.

About

python-sql is a library to write SQL queries in a pythonic way. Simple selects, select with where condition. Select with join or select with multiple joins. Select with group_by and select with output name. Select with order_by, or select with sub-select. Select on other schema and insert query with default values. Insert query with values, and insert query with query. Update query with values. Update query with where condition. Update query with from the list. Delete query with where condition, and delete query with sub-query. Provides limit style, qmark style, and numeric style.

Platforms Supported

Windows Supported
Mac Supported
Linux Supported
Cloud Not Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Platforms Supported

Windows Supported
Mac Supported
Linux Supported
Cloud Not Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Audience

Enterprises interested in a SQL query tool to run SQL scripts and export/import features

Audience

Developers searching for a solution offering a library to write SQL queries

Support

Phone Support Supported
24/7 Live Support Supported
Online Supported

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Supported

API

Offers API Not Supported

API

Offers API Supported

Screenshots and Videos

Screenshots and Videos

Pricing

No information available.
Free Version Supported
Free Trial Not Supported

Pricing

Free
Free Version Supported
Free Trial Not Supported

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported

Training

Documentation Supported
Webinars Supported
Live Online Not Supported
In Person Not Supported

Company Information

SQL Workbench
Founded: 2020
www.sql-workbench.eu/

Company Information

Python Software Foundation
United States
pypi.org/project/python-sql/

Alternatives

Alternatives

Postbird

Postbird

Paxa
NGS-IQ

NGS-IQ

New Generation Software

Categories

Database Supported
Database Clients Supported

Categories

Integrations

Domino Enterprise AI Platform Not Supported
Python Not Supported
QueryPie Supported
Visplore Not Supported

Integrations

Domino Enterprise AI Platform Supported
Python Supported
QueryPie Not Supported
Visplore Supported
Claim SQL Workbench and update features and information
Claim SQL Workbench and update features and information
Claim python-sql and update features and information
Claim python-sql and update features and information