import sqlglot sqlglot.transpile("SELECT STRFTIME(x, '%y-%-m-%S')", read="duckdb", write="hive")[0]"SELECT DATE_FORMAT(x, 'yy-M-ss')"As another example, let's suppose that we want to read in a SQL query that contains a CTE and a cast to REAL, and then transpile it to ...