Search Results for "sql queries"

...Apache Pinot supports dimension lookup joins currently. Full SQL join support in Apache Pinot is coming soon. In the interim, full SQL joins can be performed by querying Pinot via the Trino or PrestoDB connector. Apache Pinot provides SQL interface for querying interactively, as well as programmatically via rest-api.

Fully open source, cloud-native, scalable, micro streaming, and complex event processing system capable of building event-driven applications for use cases such as real-time analytics, data integration, notification management, and adaptive decision-making. Event processing logic can be written using Streaming SQL queries via graphical and source editors, to capture events from diverse data sources, process and analyze them, integrate with multiple services and data stores, and publish output to various endpoints in real time. Agile development experience with SQL-like query language and graphical drag-and-drop editor supporting event simulation. ...

LitePal is an open-source Android library designed to simplify working with SQLite databases. It uses an object-relational mapping approach so developers can perform most database operations without writing SQL. Models can be mapped directly to database tables with minimal configuration. The library automatically handles table creation, alteration, and deletion as application models evolve. It provides APIs for saving, updating, deleting, querying, aggregate operations, and transactions. LitePal also supports multiple databases, fluent queries, Java and Kotlin development, and direct SQL when greater control is required.

UCanAccess is a pure Java JDBC Driver implementation which allows Java developers and JDBC client programs to read/write Microsoft Access database (.mdb and .accdb) files. No ODBC needed.

...It was developed to support the Software-Independent Archival of Relational Databases (SIARD) of the Swiss Federal Institute. It is based on the project Jackcess for accessing MS Access files and makes use of the project H2 for parsing SQL. It is an alternative to the JDBC interface UCanAccess, whose metadata and type support and very limited SQL for DDL and DML queries could not be adapted for the purposes of SIARD. Currently EnterAccess queries are limited to a single table. All DML and DDL queries are limited by the capabilities of Jackcess, which is good at reading a database and weak on creating a view, creating foreign keys, or modifying a schema.

Imagine being able to extract from your Enterprise Content Management System, all the metadata of your documents using simple queries with a query language very close to the traditional SQL. Imagine using the information extracted for statistical purposes, for creating reports and, more generally, to analyse your document archives in a way unthinkable until now with the current tools available. All this is possible within the Pentaho Suite, the Open Source Business Intelligence platform, which is useful to the extraction and analysis of structured and semi-structured data. ...

[NO LONGER UPDATED] The Simple Hibernate Data Handler implements a basic interface for CRUD, suportting HQL, Named Queries and SQL. Stupidly simple for Hibernate ORM 4. Extend a BasicCrud class and enjoy!

CjQ (Complex Java Queries) is a library intended to introduce functional programming features in Java. One feature is the reducing of information brought by complex Java objects by simply selecting the fields you want to give away. It's SQL-like.