Problem

When using the InfluxDB data source in SQL mode, the query builder can't run queries with a wildcard column name (SELECT *). Choosing * in the Column select leads to an error:

flightsql: rpc error: code = InvalidArgument desc = Error while planning query: Schema error: No field named "*".

Example query on main

This happens because we are wrapping all column names in double-quotes and not considering * as a special case:

Proposed solution

When the column name is *, do not wrap the column name in double-quotes.

I made this change locally, and everything worked as expected:

function formatTableName(parameter: string | undefined): string {
  if (parameter === '*') {
    return parameter;
  }

  return `"${parameter}"`;
}


export function toRawSql({ sql, table }: SQLQuery): string {
  // ...
  const sc = sql.columns.map((c) => ({
    ...c,
    parameters: c.parameters?.map((p) => ({ ...p, name: formatColumnName(p.name) })),
  }));
  // ...
}

Example query with code change