Ask HN: Are there any libraries that auto-build the SQL FROM statement?

3 pointspiece-meal3 comments

Im looking for a library that will auto build the SQL FROM statement from the SELECT and WHERE fields that are passed. Does such a thing exist? I built my own library but want to replace it with something that is battle tested.

Agora Key Words: SQL Query Generate ON Statement Generator

View on HN

It's not clear to me what you are asking. How can you derive a FROM clause from SELECT * ?

Perhaps you could provide an example?

Why not to use ORM ?

Ive looked into ORMs but couldnt find the functionality I was looking for. Is there a name for what I need?

From what I found, it seems you need to create a object (pointer to table), which can only find tables one degree away from it (e.g. backref or foreign keys)

Reply on news.ycombinator.com