My goal is to create a set of tools for manipulating tables of a wide variety of data types from a variety of sources, that can be used by people who are not programmers. Coding languages like SQL, Python and R are out, and pulling data into tables and then accessing it via SQL is out.
The KNIME design philosophy of nodes and pipes suits the task well, but most of the nodes I can find are about either numeric data or specific academic applications, and that doesn’t suit my purpose. I’m not interested in Big Data or Spark, or massive scale. Think of the things that people tend to choose Excel, Access or similar tools. I need nodes that can do things like SQL (SELECT, JOIN, GROUP etc) on CSV or XLS files or other data sources, and the final output will be most likely pivot tables, charts and reports.