android - Room: pass columns Name as parameter in DAO Method

Question

I m using Room to query a table from my local Android sqlite database.

I've created an abstract class Dao , and wondering if i can pass the name of columns as parameters in method like this :

@Query(value = "SELECT :columnName "
        + " from " + Constant.TABLE_NAME
)
public abstract Maybe<List<SomeEntity>> getResults(String columnName);

Answer 1

No, sorry, that is not supported. Room only supports what SQLite does, and SQLite does not support parameters for column names, table names, etc.