5 dépôts
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 est une collection de bibliothèques d'extension SQLite implémentées sous forme de bibliothèques partagées basées sur C. Elle fournit une suite de fonctions scalaires et de fonctions renvoyant des tables supplémentaires qui étendent les capacités natives du moteur de base de données SQLite. Le projet fournit des ensembles d'outils spécialisés pour la cryptographie, les mathématiques avancées, le réseau et l'accès au système de fichiers. Ceux-ci incluent le hachage et l'encodage binaire, l'analyse statistique, la validation d'adresses IP et la capacité de mapper des fichiers CSV ou des chemins de système de fichiers en tant que tables virtuelles. La bibliothèque inclut également des outils complets de traitement de texte tels que les expressions régulières, la correspondance floue (fuzzy matching) et la manipulation de chaînes compatible Unicode. Des capacités supplémentaires couvrent la gestion de haute précision des dates et heures et la génération d'identifiants uniques.
Supports table-valued functions that return multiple rows via internal select statements.