5 个仓库
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 是一个实现为 C 语言共享库的 SQLite 扩展库合集。它提供了一套额外的标量和表值函数,扩展了 SQLite 数据库引擎的原生功能。 该项目为密码学、高等数学、网络和文件系统访问提供了专门的工具集。这些包括二进制哈希和编码、统计分析、IP 地址验证,以及将 CSV 文件或文件系统路径映射为虚拟表的能力。 该库还包括全面的文本处理工具,如正则表达式、模糊匹配和 Unicode 感知字符串操作。其他功能涵盖高精度日期和时间管理以及唯一标识符的生成。
Supports table-valued functions that return multiple rows via internal select statements.