Skip to main content
  1. About
  3. Stack Internal
The 2026 Annual Developer Survey is live— take the Survey today!
Filter by
Sorted by
Tagged with
Filter by Employee ID
Best practices
0 votes
1 replies
102 views

I'm currently working on a migration from Oracle Database to PostgreSQL using jOOQ (version 3.19.6), and I’ve run into a behavioral difference with the TRUNC function. Problem In Oracle, TRUNC is ...
Score of 2
1 answer
144 views

I'm using jOOQ with PostgreSQL and want to execute a query with an EXPLAIN (ANALYZE, FORMAT JSON) prefix. I set the parser settings to ignore comments: Settings settings = new Settings() ...
  • reputation score 61
Score of 0
1 answer
86 views

I'm trying this code where I want to convert T-SQL to databricks-SQL and I'm trying to change only the uncommon by first defining the common keywords and check it against the parsed list. I want the ...
  • reputation score 11
Score of 0
1 answer
409 views

I have been trying to create a python script that will parse some pretty complex SQL and return a dataframe of all of the columns, tables, and databases being queried as well as section indicators of ...
  • reputation score 31
Score of 1
0 answers
86 views

I tried to parse SQL queries using Microsoft.SqlServer.Management.SqlParser librairies. I didn't find any complete (or updated topics) documentation about it. So far, here's my code: Imports Microsoft....
  • reputation score 469
Score of 0
0 answers
138 views

I'm writing a code to expand a SELECT query that uses * or alias.* into SELECT query with defined column names. The idea is to supply the query, table list and associated column list and return a ...
  • reputation score 21
Score of -1
1 answer
253 views

while setting up Apache-Superset (I installed Superset on Ubuntu 22.04 over pypi, for the connector im using pinotdb, to connect Superset to a apache-pinot db.) i encountered following error after ...
Score of 0
2 answers
186 views

In a console Google Cloud project I have several datasets with tables/views in them, so most of them have the query from which they came. I am trying to parse every single one of them to get their ...
  • reputation score 441
Score of 0
0 answers
65 views

i was writing a sql parser, i use cmake configure my project. source code directories are as follows: ├── build ├── CMakeLists.txt // root CMakeLists.txt └── src ├── CMakeLists.txt //...
  • reputation score 1
Score of 1
1 answer
185 views

I recently encountered a parsing issue while using jOOQ to parse SQL queries containing Oracle's DUAL table with an alias. Here's a simplified version of the query that reproduces the issue: private ...
  • reputation score 61
Score of 0
0 answers
71 views

I'm working on a project where I need to parse SQL queries and determine if the final SQL output will be ordered or not. I am checking based on the presence of an ORDER BY clause. Here's what I've ...
  • reputation score 43
Score of 0
0 answers
113 views

I am using " https://github.com/andialbrecht/sqlparse/discussions/761 " My invoke program is " print(sqlparse.format(first, reindent=True, keyword_case='upper', ofrmt='python', ...
  • reputation score 1
Score of 0
1 answer
159 views

Hi I am using Microsoft ScriptDOM parser (Microsoft.SqlServer.TransactSql.ScriptDom) to parse the SQL queries. For a decision making in my logic I want to know all the table names and their alias in a ...
  • reputation score 63
Score of 0
0 answers
88 views

I cannot use _ when doing get_partitions Boto3 call for filtering partitions by using Expression parameter: response = client.get_partitions( Expression="partition_name LIKE '%_20231202%-%'&...
Score of 1
1 answer
470 views

I'm working with sqlparse and defining my own custom keywords for the dialect I'm using, but I'm noticing that if my keyword 'FACET' appears after my WHERE clause, it gets grouped into the WHERE's ...
  • reputation score 99

15 30 50 per page
1
2 3 4 5
...
10

AltStyle によって変換されたページ (->オリジナル) /