Search Results for "sql query"
Sort By:
Showing 27 open source projects for "sql query"
View related business solutions-
Premier Construction SoftwareRated #1 Construction Accounting Software by Forbes Advisor in 2022 & 2023. Our modern SAAS solution is designed to meet the needs of General Contractors, Developers/Owners, Homebuilders & Specialty Contractors.
-
Skillfully - The future of skills based hiringSkillfully transforms hiring through AI-powered skill simulations that show you how candidates actually perform before you hire them. Our platform helps companies cut through AI-generated resumes and rehearsed interviews by validating real capabilities in action. Through dynamic job specific simulations and skill-based assessments, companies like Bloomberg and McKinsey have cut screening time by 50% while dramatically improving hire quality.
-
1
Cube
Universal semantic layer platform for AI, BI, spreadsheets
...It helps data engineers and application developers access data from modern data stores, organize it into consistent definitions, and deliver it to every application. Cube was designed to work with all SQL-enabled data sources, including cloud data warehouses like Snowflake or Google BigQuery, query engines like Presto or Amazon Athena, and application databases like Postgres. Cube has a built-in relational caching engine to provide sub-second latency and high concurrency for API requests. -
2
...With robust query capabilities, extensibility, and full PHP integration, JsonSQL offers a modern alternative to traditional SQL databases for projects with minimal hosting requirements. ⚠️ Please note: The current documentation
-
3
Miller
Miller is like awk, sed, cut, join, and sort for name-indexed data
Miller is like awk, sed, cut, join, and sort for data formats such as CSV, TSV, JSON, JSON Lines, and positionally-indexed. With Miller, you get to use named fields without needing to count positional indices, using familiar formats such as CSV, TSV, JSON, JSON Lines, and positionally-indexed. Then, on the fly, you can add new fields which are functions of existing fields, drop fields, sort, aggregate statistically, pretty-print, and more. Miller operates on key-value-pair data while the... -
4
sq data wrangler
sq data wrangler
sq is a command line tool that provides jq-style access to structured data sources: SQL databases, or document formats like CSV or Excel. sq executes jq-like queries, or database-native SQL. It can join across sources: join a CSV file to a Postgres table, or MySQL with Excel. sq outputs to a multitude of formats including JSON, Excel, CSV, HTML, Markdown and XML, and can insert query results directly to a SQL database. sq can also inspect sources to view metadata about the source structure (tables, columns, size). ... -
Field Service+ for MS Dynamics 365 & SalesforceResco’s mobile solution streamlines your field service operations with offline work, fast data sync, and powerful tools for frontline workers, all natively integrated into Dynamics 365 and Salesforce.
-
5
pyDaSSQLiteMan
An easy way to manage SQLite databases and query CSV files
Welcome to the project page for pyDaSSQLiteMan (Python Data and SQLite Manager). This application is a Python Tkinter application designed to enable easy SQLite database file manipulation, and an easy method to run SQL styled queries on CSV files. If you're not downloading the pre-compiled executable you will need Python to run this app. You can download it from http://www.python.org/ . I'd recommend something after version 3. Testing has been Windows based. SQLite is a free database... -
6
xsd2pgschema
Relational database replication tool based on XML Schema
xsd2pgschema is a Java application suite, which converts XML Schema 1.1 (hierarchical data model) to PostgreSQL DDL (relational data model) and supports XML data migration into PostgreSQL based on the XML Schema without defects on information content. It also supports full-text indexing via either Apache Lucene or Sphinx Search utilizing the relational data model. File conversion from XML to CSV, TSV, or JSON is possible as well as mapping XML Schema to JSON Schema. Obtained PostgreSQL... -
7
SQL Trace Interlace
Reads SSMS results and places the corresponding query by its results.
Make finding relevant queries from SQL Profiler easier. When working with SQL Profiler, you may be looking for which query was responsible for a given result/keyword. Profiler does not include query results, and SSMS does not make matching a query to its results simple if there is a large number of queries to review. This tool takes the SSMS query results, and places the corresponding query next to its results in a new text file. ... -
8
SPyQL
Query data on the command line with SQL-like SELECTs powered by Python
SQL with Python in the middle. SPyQL is a query language that combines the simplicity and structure of SQL with the power and readability of Python. SPyQL offers a command-line interface that allows running SPyQL queries on top of text data (e.g. CSV, JSON). Data can come from files but also from data streams, such as as Kafka, or from databases such as PostgreSQL. -
9
dsq
Commandline tool for running SQL queries against JSON, CSV, Excel
Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more. This is a CLI companion to DataStation (a GUI) for running SQL queries against data files. So if you want the GUI version of this, check out DataStation. -
The Most Powerful Software Platform for EHSQ and ESG ManagementChoose from a complete set of software solutions across EHSQ that address all aspects of top performing Environmental, Health and Safety, and Quality management programs.
-
10
sql-servant
Personal Query Servant
In your job, do you have queries that you are running regularly and sometimes you need to share those to non-technical people? Now you can do with your personal SQL Servant. Just configure and test it, if all is good distribute it. Those people doesn't need to have any fancy licensed SQL client. -
11
xplordb
Open mineral exploration database system
Now also living on gitlab. https://gitlab.com/mds-/xplordb Mineral Exploration Database template/ system for Postgres/PostGIS and QGIS. The project incorporates import scripts, data storage, validation, reporting, 3D drill trace generation and more. psql, pgAdmin and QGIS are the suggested database and GIS front-end programs. -
12
C-squares
Concise spatial query and representation system (c-squares)
C-squares is an easily implemented method for storage, querying and display of spatial data locations, based on a hierarchical, grid-based representation of the Earth' surface. Source code for encoding, decoding, mapping, etc. is provided via this site. Additional support is available by contacting the system developer, Tony.Rees@marinespecies.org; see also the c-squares home page at http://www.cmar.csiro.au/csquares/ . -
13
rq
A tool for doing record analysis and transformation
This is the home of the tool called rq (record query). It's a tool that's used for performing queries on streams of records in various formats. The goal is to make ad-hoc exploration of data sets easy without having to use more heavy-weight tools like SQL/MapReduce/custom programs. rq fills a similar niche as tools like awk or sed, but works with structured (record) data instead of text. -
14
jdbc2csv.jar
Command-line sql JDBC tool
jdbc2csv is a small command-line tool written in JAVA and can be used on all platforms, for which JRE 8 or higher is available. To connect to a specific DBMS the tool uses its JDBC driver. The result of the executed 'select' query is displayed in CSV format ( different standards are supported ). When there is an error the tool stops with exit code 1 and the error message is output on stderr. jdbc2csv is created with a main purpose to be used in shell-scripts. Relatively easy to configurate,... -
15
QAL
Query Abstraction Layer
Project has moved to: https://github.com/OptimalBPM/qal QAL is a collection of libraries for mining, transforming and writing data from and to a number of places. Sources and destinations include different SQL and NoSQL backends, file formats like .csv, XML and excel. Even untidy HTML web pages. It has a database abstraction layer that supports connectivity to Postgres, MySQL, DB2, Oracle, MS SQL server. JSON and MongoDB is coming. It uses XML/JSON formats(self-generated SQL... -
16
Document Object Model Structured Query Language! Example: 'SELECT {//title[1]=>innerCode} FROM {http://example.com}';
-
17
SQLui
SQL user interface for JSON
SQLui is a tool that enables the handling of JSON files via SQL commands. You can also use the SQLui class to optimize the query to JSON files using SQL commands. -
18
SITools2 is a new CNES generic tool performed by a joint effort between CNES and scientific laboratories. The aim of SITools is to provide a self-manageable data access layer deployed on already existing scientific laboratory databases.
-
19
SSQML
A schema to describe ANSI/ISO SQL in XML and associated tools
SSQML: Standard Structured Query Markup Language This is an XML dialect that allows any valid SQL statement, clause, expression, predicate, or query to be expressed fully in XML based on an XML compliant schema. The schema is based on Backus Normal Form (BNF) representations of ANSI-ISO/IEC SQL Standards; ISO/IEC 9075 :2003, ISO/IEC 9075 :2006, ISO/IEC 9075 :2008, ISO/IEC 9075-14 :2013 XML-Related Specifications (SQL/XML) Does not include support for Embedded SQL Ada, C, COBOL, Fortran, MUMPS, Pascal, or PL/I programs. ... -
20
pilot-qof provides a query interface to data on a Palm device, using pilot-link and QOF - the Query Object Framework. pilot-qof supports reading addressbook, datebook, expenses and ToDo data and runs SQL-type queries on the live data or a QSF XML fil
-
21
-
22
ACCESSdb is a JavaScript library used to dynamically connect to and query locally available Microsoft Access database files within Internet Explorer.
-
23
reportmaker allows you to define a generic report in xml containing sections,graphs,tables,images. The data can be retrieved directly with sql query. The report can be exported in various formats (html,xml,rtf,pdf)
-
24
-
25
A cgi program written in Python that turns HTTP GET and POST queries into SQL queries, runs them, turns the results into XML, and then returns the XML as the response to the HTTP query. It also supports returning a single BLOB as the whole response.
