How can I control the range of reads in a SQL Table

[Banksy]

Hello Guys，
How can I control the range of reads in a SQL Table, such as specifying the reads of a column instead of reading the entire table, is there such a node? Or do you need to write code in the DB Table Selector to implement it?
Thanks in advance.
BRs
Banksy

[omeraydogan]

Hello,

You can choose custom query in db table selector:

You can write a sql statement like below:

I hope this solves your problem

[Banksy]

Hi, @omeraydogan ,
What I want to choose is the data structure of the columns, not the rows.

[omeraydogan]

Hi @Banksy ,

You can wrote a sql statement like below. Instead of * you can write column names.

SELECT column1, column2, column3 FROM #table#

If there is type you want to choose, you should add conditions like this:

SELECT column1, column2, column3 FROM #table#WHERE

[ipazin]

Hello @Banksy,

are you looking for DB Column Filter node or?

Br,
Ivan

[mlauber71]

@Banksy what kind of database are we talking about? Most databases allow for the query of meta data to get names of columns and types and so on.

[Banksy]

Hi @ipazin
I want to lock the read range of the DB table, and I don’t want to affect my workflow because the data structure of the DB table changes.