Builtin support select from sqlite_schema

[raidenluikang]

I couldn't find a way how to select arbitrary columns from SQLITE builin table sqlite_schema.

Could add this feature?

reference: https://www.sqlite.org/schematab.html

[fnc12]

what exactly do you need to query?

[raidenluikang]

I use following query:
select sql from sqlite_master where type = 'table' order by tbl_name asc

//NOTE: sqlite_master is alias of sqlite_schema table.

But why limit with the concrete query?

Generic case, may be useful the select any column from sqlite_schema table with any where condition with ordery by , offset limit functionality.

[fnc12]

ok we can add sqlite_master as a struct in the library as we did with sqlite_orm::dbstat struct. It may allow calling raw storage.select(&sqlite_master::sql) which will return std::vector<std::string>. @raidenluikang what do you think?

[raidenluikang]

@fnc12 I think that , it is a good idea. Only I suggest use original sqlite_schema name instead of old aliases as sqlite_master, sqlite_temp_schema, or sqlite_temp_master.

reference: https://www.sqlite.org/schematab.html

Thanks.

[fnc12]

@raidenluikang @trueqbit I guess we can close this issue. @raidenluikang is everything good?

[fnc12]

closing due to inactivity