Awesome GitHub RepositoriesMapping-to-SQL Converters

Archery is a suite of specialized utilities for database schema migration, SQL audit and review, mapping parsing, and performance analysis. It functions as a centralized platform for reviewing, executing, and auditing SQL queries across multiple database environments through controlled workflows. The platform includes a mapping parser that converts XML files into readable SQL statements to simplify the review of application-generated queries. It also provides tools for parsing slow query logs and analyzing execution patterns to optimize database indexes and speeds. The system covers broad da

Supersonic ist eine LLM-basierte Datenanalyseplattform und eine Engine für semantische Layer, die natürlichsprachliche Fragen in ausführbare SQL-Abfragen übersetzt. Sie fungiert als Business-Intelligence-Dashboard und Text-zu-SQL-Schnittstelle, die es Benutzern ermöglicht, Geschäftskennzahlen und Erkenntnisse über eine Konversationsschnittstelle abzurufen. Das System entkoppelt Geschäftsdefinitionen von physischen Datenbankschemata, indem es einen verwalteten logischen Layer verwendet, um einheitliche Metriken und Dimensionen zu definieren. Diese semantische Modellierung ermöglicht es der Plattform, menschliche Sprachmuster auf kuratierte Modelle abzubilden und abstrakte semantische Aussagen in physisches SQL zu übersetzen, das auf spezifische Datenbank-Engines zugeschnitten ist. Die Plattform bietet ein Enterprise-Data-Gateway mit rollenbasierter und granularer Zugriffskontrolle auf Datensatz-, Spalten- und Zeilenebene. Zu ihren Fähigkeiten gehören Multi-Turn-Dialogmanagement, Multi-Datenbank-Konnektivität und eine Plugin-Architektur für die Integration von Drittanbieter-Tools. Das Projekt stellt seine Funktionalität über eine Headless-Programmatic-API und eine Semantic-Layer-API für den externen Datenkonsum bereit.

Cerbos is an open-source authorization service that provides a centralized, language-agnostic engine for managing access control. It functions as a policy-as-code platform, allowing teams to define, test, and distribute authorization rules using declarative YAML or JSON configurations. By decoupling access logic from application code, it enables consistent permission enforcement across diverse service stacks. The project distinguishes itself through its ability to translate high-level authorization policies into native database query filters. This capability allows applications to enforce sec

FreeSql is a .NET object-relational mapper and data access layer that translates object-oriented code into SQL for multiple relational database providers. It functions as a fluent SQL query builder and database schema synchronizer, allowing developers to align database table and index structures with entity class definitions. The framework is specifically optimized for .NET Native AOT to ensure reduced memory footprints and faster startup times. It includes a database traffic manager to distribute load through read-write splitting, dynamic table sharding, and tenant-based data isolation. Bro

Mapperly is a C# source generator used for high-performance object-to-object mapping in .NET. It functions as a compile-time mapping library that produces the necessary transformation code during the build process, eliminating the need for runtime reflection when converting between domain models and data transfer objects. The tool distinguishes itself by providing type-safe diagnostic validation and strict mapping enforcement, emitting warnings for unmapped properties at compile time. It includes specialized capabilities for circular reference handling and deep cloning to maintain object iden

Pony is a Python object-relational mapper that maps classes to relational database tables using an object-oriented interface. It serves as a relational database toolkit providing the means to manage database transactions, identity mapping, and the lazy loading of related records. The project is distinguished by a SQL query translator that converts Python generator expressions into optimized SQL queries by analyzing the abstract syntax tree. It also includes a visual database schema designer for creating entity-relationship diagrams to automatically generate and synchronize relational database

Kylin is a distributed OLAP engine designed for executing fast SQL queries on massive datasets. It utilizes multi-dimensional data cubes to pre-calculate data aggregates, enabling sub-second response times for large-scale analytical queries and big data analytics. The system focuses on large-scale data warehousing and multi-dimensional data modeling. It allows for the organization and querying of vast amounts of structured data to support business intelligence and reporting workflows through distributed SQL querying.