sqlparser

```sql
WITH orders AS
  (SELECT 5 as order_id,
  "sprocket" as item_name,
  200 as quantity)
SELECT * REPLACE ("widget" AS item_name)
FROM orders;
```

sqlparser

```sql
SELECT DISTINCT regexp_extract("$path", '[^/]+$') AS data_source_file
FROM sampledb.elb_logs
ORDER By data_source_file ASC
```

sqlparser

```sql
CREATE VIEW vsal 
AS 
  SELECT a.deptno                  "Department", 
         a.num_emp / b.total_count "Employees", 
         a.sal_sum / b.total_sal   "Salary" 
  FROM   (SELECT deptno, 
                 Count()  num_emp, 
                 SUM(sal) sal_sum 
          FROM   scott.emp 

sqlparser

  EXEC Spr_store_note 
    @NoteId      = 0, 
    @TableTypeId = @TABLE_CUSTOMER,
    @RecordId    = @CustomerId

sqlparser

INSERT INTO Production.Location (Name, CostRate, Availability)
VALUES 
  (
    N'Final Inventory', 
    15.00, 
    80.00
  );

sqlparser

EXEC Sptrackmember @p_member_id,'2.2',@p_weeknum 

sqlparser

DECLARE @s VARCHAR(1000),@s2 VARCHAR(10)  

sqlparser

  CREATE PROCEDURE Uspnresults  
  AS  
   SELECT Count( contactid )  
   FROM   person.contact  

  --begin_no_format  
  SELECT Count(customerid) FROM sales.customer; 
  --end_no_format  
  GO  

sqlparser

 DECLARE @find varchar(30); 

sqlparser

  SELECT 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