The SQL Business Rule has long been the superpower of the Code On Time developer. It allows you to inject validation, logging, and custom data processing directly into your application using the language you know best—SQL. For high-performance, database-specific tasks, it remains the gold standard.

But as the Code On Time platform evolves with the Digital Workforce, Builder Edition, and AI Scaffolding, there are specific scenarios where you might need a different kind of tool.

This is where the [ProjectNamespace].Data.SqlText utility class shines.

It isn't about replacing the SQL rules you love; it's about extending your reach to platforms and technologies where raw T-SQL or PL/SQL cannot go.

1. The Key to the Builder Edition (SQLite)

The Builder Edition allows you to build unlimited commercial applications for free and accelerated by the Digital Workforce. To make this portable and lightweight, it defaults to using SQLite.

While SQLite is a powerful database engine, it does not support the rich procedural languages (like T-SQL or PL/SQL) that drive standard SQL Business Rules.

• The Challenge: How do you write server-side validation logic (e.g., "Check if Customer exists") in an app running on SQLite?
• The Solution: Type: Code business rules using the SqlText class. This allows you to write standard SQL queries wrapped in C# or VB.NET, which the framework automatically translates for SQLite. It is the only way to build complex server-side logic for Builder Edition apps.

2. A Blueprint for AI Scaffolding (GEN)

We are introducing GEN (Scaffolding) capabilities that allow you to "export" your application logic to completely different technology stacks, such as Next.js, Python, or standard ASP.NET Core APIs.

• The Challenge: An AI agent cannot easily translate a block of raw T-SQL into a Node.js API route because the logic is "locked" inside the database dialect.
• The Solution: Logic written with SqlText acts as a "White Box" for the Axiom Engine. The AI can read your C# code, understand the intent, and natively re-implement it in the target language. If you plan to use your app as a specification for a custom build, SqlText ensures your business rules travel with you.

3. Debugging with "Pro Code" Tools

For complex logic, nothing beats a real debugger.

• The Advantage: Unlike SQL scripts, Type: Code rules live in your project's source files. You can use the "Edit Code" action to open your rule in Visual Studio, set breakpoints, and step through your logic while the app runs. It combines the speed of the App Studio with the precision of a professional IDE.

Learn the Pattern

We have released a comprehensive tutorial to help you add this tool to your belt. Whether you are building a portable app for the Builder Edition or preparing a specification for the Digital Workforce, this guide shows you how to write secure, database-agnostic logic.

Read the Tutorial: Using the SqlText Class in "Code" Business Rules
Master the tools that let you build anywhere, for any platform.