5 Repos
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 ist eine Sammlung von SQLite-Erweiterungsbibliotheken, die als C-basierte Shared Libraries implementiert sind. Sie bietet eine Suite zusätzlicher skalarer und tabellenwertiger Funktionen, die die nativen Fähigkeiten der SQLite-Datenbank-Engine erweitern. Das Projekt bietet spezialisierte Toolsets für Kryptografie, fortgeschrittene Mathematik, Netzwerke und Dateisystemzugriff. Dazu gehören binäres Hashing und Encoding, statistische Analysen, IP-Adressvalidierung sowie die Möglichkeit, CSV-Dateien oder Dateisystempfade als virtuelle Tabellen abzubilden. Die Bibliothek enthält zudem umfassende Textverarbeitungstools wie reguläre Ausdrücke, Fuzzy-Matching und Unicode-bewusste String-Manipulation. Zusätzliche Funktionen decken hochpräzises Datums- und Zeitmanagement sowie die Generierung eindeutiger Identifikatoren ab.
Supports table-valued functions that return multiple rows via internal select statements.