python-sql

python-sql

Python Software Foundation
+
+

Related Products

  • DbVisualizer
    522 Ratings
    Visit Website
  • SureSync
    13 Ratings
    Visit Website
  • Vertex AI
    743 Ratings
    Visit Website
  • Nutrient SDK
    98 Ratings
    Visit Website
  • TinyPNG
    46 Ratings
    Visit Website
  • Google Cloud BigQuery
    1,867 Ratings
    Visit Website
  • Teradata VantageCloud
    975 Ratings
    Visit Website
  • Cerberus FTP Server
    159 Ratings
    Visit Website
  • RaimaDB
    9 Ratings
    Visit Website
  • MASV
    68 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
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

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
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

API

Offers API

API

Offers API

Screenshots and Videos

Screenshots and Videos

Pricing

No information available.
Free Version
Free Trial

Pricing

Free
Free Version
Free Trial

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
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

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

Categories

Integrations

Domino Enterprise MLOps Platform
Python
QueryPie

Integrations

Domino Enterprise MLOps Platform
Python
QueryPie
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