Marcus - noxify Posts - Answer Overflow

Marcus - noxify

•Created by Marcus - noxify on 4/12/2024 in #help

Complex Query Builder from dynamic input - Typescript issue

Hi, it's me - again 🙂 I'm currently trying to migrate our current query builder. It seems that everything is working as expected, but I get some type errors and I'm not sure how to fix this - Maybe you have an idea how to fix this / what the rootcause is. The query is compiled and I can see it in my vitest & in the playground ( you have to open the web console 😉 ) Playground link: https://kyse.link/8cA4l It's based on: * https://kysely.dev/docs/recipes/expressions#creating-reusable-helpers * https://kysely.dev/docs/recipes/expressions#conditional-expressions

6 replies

KKysely

•Created by Marcus - noxify on 4/11/2024 in #help

How to use multiple schema definitions ( e.g. <catalog>.<schema>.<table> )

Hey guys, I'm currently working on a new version for our graphql wrapper. Currently we're using knex to generate the query - it works as expected but isn't typesafe with how we use it 🙈 I'm currently evaluating kysely and 99% seems to work. Some details: We're using trino as datasource ( via their http api ). The expected SQL Query requires to specify also the catalog name in the FROM statement. Short example:

SELECT
  fieldname
FROM
  <catalog>.<schema>.<table>
  # alternativ
  "<catalog>"."<schema>"."<table>"

SELECT
  fieldname
FROM
  <catalog>.<schema>.<table>
  # alternativ
  "<catalog>"."<schema>"."<table>"

I have tested some scenarios, but it seems I missed something. Question: Is it possible to generate this kind of FROM statement with kysely? here the playground link: https://kyse.link/EaWQ3

15 replies

Gaming

Programming