Rethinking SQL for Infor CloudSuite: Code, Visual Tools, and AI-Driven Data Workflows

Instead of writing SQL, users can build queries visually — selecting tables, choosing fields, and applying filters with just a few clicks. This is made even easier through a dedicated Infor data dictionary layer, along with integrated search and preview tools. It’s the fastest way to go from question to insight, especially for those who don’t work with SQL every day.

When precision matters, nothing beats writing SQL directly. The Query tool gives power users full control to shape exactly how data is retrieved, combined, and filtered. It’s where complex logic, performance tuning, and deep data exploration come together. If you have your query ready from another system, you can simply copy and paste it to start getting results.

Data is rarely static and neither are the questions behind it. With simple “from” and “to” inputs, easily selected through zoom-to-table, along with other parameterized values, queries become interactive tools, empowering end users to shape results dynamically — without ever touching the underlying SQL.

These input forms can also be exposed as deep hyperlinks with parameters, allowing them to be triggered directly from outside the B2Win Suite platform. This enables embedding reports into operational systems and makes it easy to move from context to insight in a single step.

SQL is declarative — it defines what you want. Scripting is procedural — it defines how to do it. B2Win Suite brings both approaches together within a single low-code platform. It combines procedural scripting with declarative SQL, allowing users to build flexible, end-to-end workflows. Some nodes operate procedurally, others declaratively — and they can be seamlessly integrated. Within a script, you can execute SQL against any database or query in-memory data frames, blending logic and data access in a single flow.

All of this is powered through the FlowCode Editor, which includes an AI agent for scripting and code generation, auto-complete, console logging, and a modern interface. The built-in sidebar — featuring fields, properties, utilities, and snippets — not only accelerates development but also provides the context for AI agent-assisted scripting, enabling more accurate and relevant code generation while accelerating workflow development.

Sometimes, the requirement goes beyond querying data — it’s about continuously tracking what’s new. Query Trigger enables incremental data retrieval by monitoring a specific field, such as an ID or timestamp, and keeping track of its maximum value.

Each time the trigger runs, it executes the defined query but returns only records where that field exceeds the previously stored maximum. As new records are added, the trigger automatically initiates the next iteration, ensuring that only new data is processed.

The result is an efficient, continuous data flow — output directly into a data frame — without reprocessing existing records.

Working with data doesn’t stop at retrieving it — you often need to shape it after retrieval. In B2Win Suite, the DataPrep node provides a graphical way to prepare and manipulate data, making it easy to quickly structure and refine datasets visually without writing code.

Query in Memory extends this flexibility. Instead of relying solely on predefined transformations, users can run SQL directly on one or multiple in-memory data frames, enabling more advanced logic, deeper transformations, structural changes, and complex aggregations that go beyond typical visual tools.

It is powered through a modern editor with an AI agent for SQL generation, auto-complete, and console logging. The built-in sidebar, featuring fields and properties, can be directly used within queries and provides the context for AI agents, enabling more accurate and relevant code generation while reducing the complexity of advanced data workflows.