sqlitis
sqlitis copied to clipboard
Convert sql to sqlalchemy expressions
And provide a open flask-like webapp so we can convert on the fly without needing to install locally. Love ya
Let me first show the output for one of your examples. $ sqlitis "SELECT id FROM foo WHERE id = 128" select([foo.c.id]).where(text('id') == 128) That looks good to me, so...
# Description I tried using `sqlitis` to convert a SQL query and received an error. ## Failing command (required) ``` FIXME: PASTE SQLITIS COMMAND AND FULL OUTPUT HERE sqlitis "select...
# Description I tried using `sqlitis` to convert a SQL query and received an error. ## Failing command (required) ``` [BUG] Failed to convert CONCAT(distributorToUserFund.fundName, '__' ,distributorToUserFund.adviserUsername) to model ```...
Blocks #22 If we try `sqlitis 'select t.name from foo t'`, it could do two things, 1. Resolve table aliases: It would return `select([foo.c.name])`. This would mean maintaining a dict...
Please add many functions. [https://dbfiddle.uk/?rdbms=postgres_9.6&fiddle=04645a18d4d4082cf4cee40545473015](url) ```WITH timeslots AS ( SELECT * FROM ( SELECT tsrange(timepoint, lead(timepoint) OVER (ORDER BY timepoint)), lead(timepoint) OVER (ORDER BY timepoint) FROM ( SELECT unnest(ARRAY[start, "end"])...
``` $ sqlitis "select count('typeID'),character_id from skills where active>0 and ('typeID'=3337 or 'typeID'=3336 or 'typeID'=12212) group by character_id having count('typeID') =3" ERROR: Failed to convert SQL: select count('typeID'),character_id from skills...
sqlitis does not recognize that an unqualified column in a where clause belongs to a particular table, especially when only one table is involved in the query. Current behavior, ```...
Tried the following: sqlitis 'SELECT DISTINCT last_name, first_name,addressee_display, street_address, city, a.name, postal_code, f.name as country FROM civicrm_contact c, civicrm_entity_tag d , civicrm_address e, civicrm_state_province a, civicrm_country f WHERE c.id =...
Bumps [sqlparse](https://github.com/andialbrecht/sqlparse) from 0.3.0 to 0.4.4. Changelog Sourced from sqlparse's changelog. Release 0.4.4 (Apr 18, 2023) Notable Changes IMPORTANT: This release fixes a security vulnerability in the parser where a...