Show HN: Natural-SQL-7B, a strong text-to-SQL model

Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model by 3rd3 on Monday February 05, 2024 @01:02PM (#39264360)

What is the point of the cross join? This would work as well:

   SELECT loop.value, loop.value * loop.value
   FROM generate_series(1,5) AS loop(value)

[ Parent | on HN ]

Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model by ComputerGuru on Monday February 05, 2024 @02:36PM (#39265926)

For this example, nothing. It would be useful where neither of the two SELECT queries is a subset/superset of the other. (Not saying you didn't know that.)

[ Parent | on HN ]

Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model by 3rd3 on Monday February 05, 2024 @02:42PM (#39266026)

Could you give an example?

[ Parent | on HN ]

Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model by ako on Monday February 05, 2024 @03:13PM (#39266464)

This will be useful if you have a table with some related history records, e.g., products with product price history, and you want to get the latest price. The lateral join would get all prices for the current product, sort them by date and then pick the top row.

[ Parent | on HN ]

Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model by 3rd3 on Monday February 05, 2024 @03:36PM (#39266790)

How does a lateral (cross) join compare to a window function in your example?

[ Parent | on HN ]

Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model by ses1984 on Monday February 05, 2024 @09:40PM (#39270113)

Is a lateral join more efficient than just saying where product = current sort by date desc ?

[ Parent | on HN ]