5 repository-uri
Execution of functions that return tables directly within SQL queries.
Distinct from External Table Querying: Distinct from External Table Querying: focuses on function-based table generation rather than external database virtualization.
Explore 5 awesome GitHub repositories matching data & databases · Table Function Invocation. Refine with filters or upvote what's useful.
Presto is a distributed SQL query engine designed for high-performance analytical processing across heterogeneous data sources. It functions as a data federation platform and massively parallel processing engine, allowing users to execute interactive queries against diverse storage systems without requiring data migration. By mapping remote metadata and structures to a unified relational namespace, it enables seamless cross-platform analysis through a standard SQL interface. The engine distinguishes itself through a pluggable connector architecture and a shared-nothing distributed processing
Executes functions that return tables directly within SQL queries for dynamic data processing.
Entity Framework Core is an object-relational mapper that enables developers to interact with database systems using strongly-typed code. It serves as a comprehensive data access framework, providing a unified interface for mapping application objects to relational and non-relational database schemas while managing the lifecycle of data operations through a central context. The project distinguishes itself through a provider-based architecture that decouples core data access logic from specific database engines, allowing for consistent interaction across diverse storage systems. It features a
Provides support for mapping application methods to database table-valued functions for parameterized result set retrieval.
SQLAlchemy is a comprehensive Python SQL toolkit and object-relational mapper that provides a full suite of tools for interacting with relational databases. It serves as a foundational layer for database connectivity, offering both a high-level object-oriented interface for data persistence and a programmatic SQL expression language for constructing complex, dialect-agnostic queries. The project distinguishes itself through its sophisticated unit of work persistence, which coordinates atomic transactions and tracks object state changes to minimize redundant database operations. It provides a
Maps database functions that return sets of rows directly to queryable table aliases within SQL statements.
Apache Hive is a SQL-on-Hadoop data warehouse that enables querying and managing petabytes of data stored in distributed storage such as HDFS and cloud storage services. It provides a familiar SQL interface for batch analytics and reporting, supported by a core set of components including the HiveServer2 Thrift service for remote query execution, the Hive Metastore Service for central metadata management, the Hive ACID Transaction Engine for concurrent read-write operations, and the Hive LLAP Interactive Engine for low-latency analytical processing. The WebHCat REST API offers an HTTP interfac
Applies a user-defined table-generating function to each input row and joins the output rows to the original input.
sqlean este o colecție de biblioteci de extensii SQLite implementate ca biblioteci partajate bazate pe C. Oferă o suită de funcții scalare și tabelare suplimentare care extind capabilitățile native ale motorului de bază de date SQLite. Proiectul oferă seturi de instrumente specializate pentru criptografie, matematică avansată, rețelistică și acces la sistemul de fișiere. Acestea includ hashing și codificare binară, analiză statistică, validarea adreselor IP și capacitatea de a mapa fișiere CSV sau căi din sistemul de fișiere ca tabele virtuale. Biblioteca include, de asemenea, instrumente cuprinzătoare de procesare a textului, cum ar fi expresii regulate, potrivire fuzzy și manipularea șirurilor de caractere conștientă de Unicode. Capabilitățile suplimentare acoperă gestionarea de înaltă precizie a datei și orei și generarea de identificatori unici.
Supports table-valued functions that return multiple rows via internal select statements.