Translate your SQL from one dialect to another
Format, pretty print, and translate your SQL from one dialect to another

    
        SQL Translation
    

    
		    Use the jOOQ Parser to translate any SQL statement(s) to a different dialect.*
        
    
        
        
        
            
                -- Put your SQL statement here
                
            
        
        
            
                -- Put your schema definition here (optional)
--                
-- While this is not a strict requirement, you will 
-- get much better results as jOOQ knows about constraints, 
-- data types, column names, etc. Especially when 
-- translating to jOOQ/Java code, in case of which the
-- resulting jOOQ code can table and column references 
-- from the code generator.
                
            
        
        
        

        
            
        Input Dialect
        
            
        
    
    
        Search path, comma separated
        
            
         
    
    
        Parse unknown functions
        
            
         
    
    
        Formats
    
    
        Date Format
        
            
         
        
    
        Timestamp Format
        
            
         
        
    
        Comments
    
    
        Retain comments between queries
        
            
         
    
    
        Enable ignore comment syntax
        
            
         
    
    
        Ignore comment start token
        
            
         
    
    
        Ignore comment stop token
        
            
         
    
            
	

    
        
        

        
            
        Output Dialect
        
            
        
    
    
        Keywords
        
            
        
    
    
        Identifier Case
        
            
        
    
    
        Identifier Quoting
        
            
        
    
    
        Bind variables
        
            
        
        
        Transformation options
    
    
        Patterns (experimental)
        
            
        
    
    
        Join style
        
            
        
    
    
        QUALIFY
        
            
        
    
    
        ROWNUM
        
            
        
    
    
        inline CTE
        
            
        
    
    
        GROUP BY <column index>
        
            
        
    
    
        Remove unnecessary arithmetic
        
            
        
    

    
        Stylistic options
    
    
        AS keyword in SELECT
        
            
        
    
    
        AS keyword in FROM
        
            
        
    
    
        INNER keyword in JOIN
        
            
        
    
    
        OUTER keyword in JOIN
        
            
        
            
            More formatting Options
            Coming soon!
        
        
    

    
    

    
