General SQL Parser and SQL Pretty Printer Formatter options

Index

TrueLeft works only following format options set correspondingly, how to set those format options in sql pretty printer desktop version

option value
TrueLeft 1
Select_keywords_alignOption left
andorunderwhere true
AlignJoinWithFromKeyword 1
Select_FromclauseJoinOnInNewline 1
AlignAndOrWithOnInJoinClause 1
Select_FromclauseJoinConditionInNewline 0

Formatted SQL:

SELECT DISTINCT
       p.name      AS product,
       p.listprice AS 'List Price',
       p.discount  AS 'discount'
FROM   production.product p
JOIN   production.productsubcategory s
ON     p.productsubcategoryid = s.productsubcategoryid
AND    p.id = s.id
WHERE  s.name LIKE @product
AND    p.listprice < @maxprice
AND    EXISTS(SELECT *
              FROM   apps.per_assignments_f asg
              WHERE  asg.assignment_type NOT IN ( 'B' )
              AND    b > 1
              OR     c > 2)
OR     p.price     = 100; 

option value
TrueLeft 0
Select_keywords_alignOption left
andorunderwhere true
AlignJoinWithFromKeyword 1
Select_FromclauseJoinOnInNewline 1
AlignAndOrWithOnInJoinClause 1
Select_FromclauseJoinConditionInNewline 0

Formatted SQL:

SELECT DISTINCT
       p.name      AS product,
       p.listprice AS 'List Price',
       p.discount  AS 'discount'
FROM   production.product p
JOIN   production.productsubcategory s
  ON p.productsubcategoryid = s.productsubcategoryid
 AND p.id = s.id
WHERE  s.name LIKE @product
   AND p.listprice < @maxprice
   AND EXISTS(SELECT *
              FROM   apps.per_assignments_f asg
              WHERE  asg.assignment_type NOT IN ( 'B' )
                 AND b > 1
                  OR c > 2)
    OR p.price     = 100;