simple select demo

simpleselect.usql

DECLARE @inputfile  string = "/Data/Meny/postgres_public_customer.csv";

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

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

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

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

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