is possibel to create collection type base on sql Query im using supabase example and want to migrate to strapi example
const resolvers = {
Query: {
user: (parent, args) => {
const query = 'SELECT * FROM users WHERE id = $1';
const values = [args.id];
return db.query(query, values)
.then(data => data.rows[0])
.catch(err => new Error(err));
},
users: () => {
const query = 'SELECT * FROM users';
return db.query(query)
.then(data => data.rows)
.catch(err => new Error(err));
},
product: (parent, args) => {
const query = 'SELECT * FROM products WHERE id = $1';
const values = [args.id];
return db.query(query, values)
.then(data => data.rows[0])
.catch(err => new Error(err));
},