CRUD Support – Expanding RAW’s Capabilities for Dynamic Data Management (Coming Soon!)

At RAW, our mission is to empower you to effortlessly build and manage APIs over your existing data sources, with a strong focus on enabling AI integration. Our platform is designed to help you create APIs using SQL or our Snapi language, providing powerful tools to reduce AI hallucination through reliable function calling. By focusing on real-time data from operational systems—whether it’s relational databases, enterprise platforms, or SaaS services—we create unified ‘data products’ enriched with metadata and monitored for semantic drift. These data products are ideal for building AI chatbots and large language models (LLMs), ensuring they can access and utilize accurate, up-to-date information, making your AI-driven applications more reliable and effective

Now with CRUD Support

We’re thrilled to share that RAW will now be adding a major enhancement with CRUD support. This feature allows users to build APIs that can create, update, or delete data within your connected systems. We wanted to give our community an exclusive first look at what’s coming and how it will transform your data management workflows.

Why CRUD Support Matters

As the use of AI agents and automated workflows becomes increasingly prevalent, the ability to modify data programmatically is essential. CRUD operations will enable these agents to interact with your data in a meaningful way, facilitating tasks such as:

Creating new records or entries based on user interactions or system events.

Updating existing data to reflect changes in state, status, or other attributes.

Deleting records that are no longer needed, ensuring your data remains clean and relevant.

By integrating CRUD support, RAW will evolve from a powerful read-only API-based data virtualization platform into a comprehensive data management suite, giving you complete control over your data workflows and AI integrations.

A Glimpse into the Future: Enhancing Your JIRA Connector

To illustrate the potential of CRUD support, let’s take a closer look at how this feature will enhance our JIRA connector. Currently, you can use RAW to execute a query like:

SELECT state FROM jira_issue WHERE ticket_id = 'RD-10435';

This allows you to read the current state of a specific JIRA issue. With CRUD support, you will soon be able to perform additional operations, for example:

Update an Issue State:

UPDATE jira_issue SET state = 'done' WHERE ticket_id = 'RD-10435';

This command will enable you to update the state of the specified JIRA issue to ‘done’.

Delete an Issue:

DELETE FROM jira_issue WHERE ticket_id = 'RD-10435';

This will allow you to remove the specified issue from your JIRA system.

Insert a New Issue:

INSERT INTO jira_issue (state, description, body) VALUES ('open', 'UI hangs on resize', 'The web app...');

This will enable you to create a new JIRA issue with the provided details.

These examples highlight how CRUD operations will enhance your ability to manage and manipulate data directly through RAW’s intuitive interface, streamlining your workflows and enabling more sophisticated integrations.

Empowering Your AI-Driven Applications

With CRUD support, you can now build fully-featured AI agents using RAW, which are able to interact with your data not just by retrieving information but by making real-time changes. This enables more interactive and responsive user experiences. Whether it’s updating user profiles, managing inventory, or orchestrating complex business processes, RAW’s expanded capabilities will provide the flexibility and control needed to build intelligent, adaptive systems.

What’s Next?

We are committed to keeping you informed every step of the way and will share more details as we gradually roll out this feature to all users of our platform. In the meantime, you are welcome to participate in its development as we recently open sourced our CRUD connector framework, allowing developers to extend and customize connectors within RAW. If you’re interested in contributing or leveraging this framework for your own projects, please get in touch with the team.

Join the RAW Community

As always, thank you for being a part of the RAW community. Your support and feedback drive us to continuously innovate and improve. We can’t wait to unveil CRUD support broadly, and see how it empowers you to build even more powerful and dynamic data-driven applications. Stay tuned for more updates, and get ready to take your APIs to the next level with RAW. In the meantime, if you have questions or want to learn more about what’s coming? Visit our documentation or join our community forums to connect with other RAW users and our development team. We’re here to help you make the most of RAW.

RAW – Simplifying API Development and Data Management for the AI-Powered World

‍