subselect

subselect.usql

DECLARE @inputfile  string = "/Data/Meny/postgres_public_customer.csv";
DECLARE @cvsout string = "/Data/Meny/Output/ourcustomers2.csv";
DECLARE @tsvout string = "/Data/Meny/Output/ourcustomers2.tsv";
DECLARE @txtout string = "/Data/Meny/Output/ourcustomers2.txt";

@customers =
    EXTRACT UserId          int,
            FirstName       string,
            LastName        string,
            Address         string,
            Phone	        string
    FROM @inputfile
    USING Extractors.Csv();

@namedataset =
    SELECT FirstName, LastName
    FROM @customers;


OUTPUT @namedataset   
    TO @cvsout
      USING Outputters.Csv();

OUTPUT @namedataset   
    TO @tsvout
      USING Outputters.Tsv();

// try to output to @tvsout to demonstrate an error
OUTPUT @namedataset   
    TO @txtout
      USING Outputters.Text(delimiter: '|',quoting: false);