I would like to create a application where a sample data is displayed in Java Script tables, but we want to create SQL statement graphically so we need a mechanism to run that created SQL in-memory on server itself (not on database) or at Java Script level, so that we can display results quickly. Is there any open-source / paid solution available for doing this? What are other technology stack is possible. We want to use Java / Java Scripts.
We are creating this application now using Spring framework.