text: -- setup:
  CREATE TABLE foo;
  
  -- test: simple projection
  SELECT 1;
  /* result:
  {"1": 1}
  */
  
  -- test: complex expression
  SELECT 1 + 1 * 2 / 4;
  /* result:
  {"1 + 1 * 2 / 4": 1}
  */
  
  -- test: with spaces
  SELECT     1  + 1 *      2 /                    4;
  /* result:
  {"1 + 1 * 2 / 4": 1}
  */
  
  -- test: escaping, double quotes
  SELECT '"A"';
  /* result:
  {"'\"A\"'": "\"A\""}
  */
  
  -- test: escaping, single quotes
  SELECT "'A'";
  /* result:
  {"'\\'A\\''": "'A'"}
  */
  
  -- test: aliases
  SELECT 1 AS A;
  /* result:
  {"A": 1}
  */
  
  -- test: aliases with cast
  SELECT CAST(1 AS DOUBLE) AS A;
  /* result:
  {"A": 1.0}
  */
  
  