Automated SQL Code Generation via Template Functions

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Traditional software development involves manual coding by multiple developers, leading to heterogeneous and inefficient code that is difficult to maintain, especially when original developers are no longer available, and requires specialized programming skills, making it challenging for data scientists to access relational databases.

Innovation Solution

A system with a user device, code generation module, and data store that automatically generates bespoke computer-executable code in a domain-specific programming language, such as SQL, using helper and template functions, allowing users to input arguments and execute queries without requiring specialized programming knowledge.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If multiple developers manually write and debug code, then the code can be created with diverse perspectives, but the code becomes heterogeneous and difficult to maintain

Engineering Contradiction:

Improvecode creation capabilityVSAvoidcode maintainability

Core Design Contradiction:

Adaptability or versatilityVSEase of repair

Solution Approach 1:

The patent applies homogeneity by generating code through automated templates and helper functions that ensure consistent coding styles, structures, and patterns across all generated code. This eliminates the heterogeneity introduced by multiple developers while preserving the adaptability to create diverse code solutions through configurable templates.

Inventive Principle:

Principle #33Homogeneity

Solution Approach 2:

The system enables self-service by providing automated code generation that reduces reliance on individual developer expertise. The template-based system with helper functions allows code to be generated automatically based on specified requirements, reducing manual writing and debugging while maintaining code quality and consistency.

Inventive Principle:

Principle #25Self-service

2Adaptability or versatility

If code is manually written by individual developers, then customization and creativity are possible, but bugs increase and computational efficiency decreases

Engineering Contradiction:

Improvecode customizationVSAvoidcode quality

Core Design Contradiction:

Adaptability or versatilityVSReliability

Solution Approach 1:

The patent introduces templates and helper functions as intermediaries between user requirements and final code output. These intermediaries encapsulate best practices, validated logic, and proven patterns, thereby reducing bugs while preserving customization capabilities through configurable template parameters and selectable helper functions.

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The system applies preliminary action by pre-defining code templates and helper functions that contain validated, bug-free code structures. This preliminary preparation ensures that generated code inherits reliability from the pre-tested templates while allowing customization through parameter configuration, thus improving code quality without sacrificing adaptability.

Inventive Principle:

Principle #10Preliminary action

3Productivity

If specialized programming skills are required to access relational databases, then complex queries can be written, but the barrier to entry increases and usability decreases

Engineering Contradiction:

Improvequery capabilityVSAvoiduser accessibility

Core Design Contradiction:

ProductivityVSEase of operation

Solution Approach 1:

The patent uses graphical user interface elements and template-based query construction as intermediaries between users and complex SQL queries. Users interact with simplified visual elements that automatically translate into sophisticated database queries, thereby maintaining high query capability while dramatically improving ease of operation for non-technical users.

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The system replaces the mechanical system of manual SQL writing with an automated template generation mechanism. The template-based approach with helper functions automatically constructs complex queries based on user selections, substituting the need for manual programming with an automated process that maintains productivity while improving accessibility.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

Data Source

PatentUS12056471B2Architecture for automatically generating computer-executable code for querying networked relational database management systems

Publication Date: 2024.08.06 EVERNORTH STRATEGIC DEVELOPMENT INC

AI summary

A system for automatically generating computer-executable code includes a user device including a communications interface, a code generation module, and a data store, and a storage device operatively coupled to the code generation module via a network and the communications interface. The storage device includes a relational database management system. The code generation module is configured to parse a selected feature from the feature library to determine a first helper function of the one or more helper functions and a selected template function of the one or more template functions, receive a first argument for the first helper function, generate a first output value by associating the first helper function with the first argument, generate precursor executable code by adding the first output value to the selected template function as a first argument of the selected template function, and execute the precursor executable code to generate bespoke code.