That is probably very straightforward to write. The nearest thing that currently exists is CloneSchema, which I would describe as a ‘caching proxy’. You could copy it and make each table return a single row of all ones. Or I would be inclined to return the ‘zero’ value for each datatype (0 for ints, false for BOOLEAN, 0.0 for floats, empty string, DATE ‘1970-1-1’, etc.).
Feel free to create a JIRA case sketching out the requirement, even if you don’t currently have time to implement it. Julian > On Jul 18, 2022, at 3:09 PM, Gavin Ray <ray.gavi...@gmail.com> wrote: > > How difficult would it be to create a proxying schema that returns the > integer value 1 for every column requested > > This would be useful for a few things probably, but one neat use it would > unlock is > the ability to use Calcite for translation between SQL dialects without > having a schema beforehand. > > You could even host a small public webservice people could use, how nifty > would that be?