alright, So i'm kind of an SQL noob here, wonderin...
# sqlm
Mike92988
11/10/2021, 1:29 PMalright, So i'm kind of an SQL noob here, wondering how i format a response from a query so that each selected field is it's own column, anybody have any ideas or know where to point me?
s
silentworks
11/10/2021, 1:42 PMCan you give an example of what you mean?
m
Mike92988
11/10/2021, 1:45 PMSo I'm running a query to get all users that have signed up within a specific time frame. I', getting the correct data on response, but I want to break it up into columns, like:
firstName || lastName || dateJoined || email
Carl Sagan 10/21/2021 carlsagan42@gmail.com
if that makes sense
s
silentworks
11/10/2021, 1:48 PMNo as that would be done in your userland code and not in the SQL query
silentworks
11/10/2021, 1:48 PMThe SQL query would return a JSON when using the Supabase library, so it would already have column name along with value
m
Mike92988
11/10/2021, 1:50 PMwell currently when I run the sql query it's just showing
row
(firstName, lastName, dateJoined, email)
s
silentworks
11/10/2021, 1:50 PM Copy code
json
{
firstName: "Carl",
lastName: "Sagan",
dateJoined: "10/21/2021",
email: "carlsagan42@example.com"
}silentworks
11/10/2021, 1:50 PMYes that's how SQL queries work, but when you call it via the
supabase-jsm
Mike92988
11/10/2021, 1:52 PMright okay, that makes sense. so would I have to create a view or something to get it formatted how I want it?
s
silentworks
11/10/2021, 1:53 PMWhat does your query look like? if its a simple select you can just use the
supabase-jsm
Mike92988
11/10/2021, 1:56 PMI actually figured it out, the problem was coming from me putting the column names in parentheses
s
silentworks
11/10/2021, 1:56 PMok cool
silentworks
11/10/2021, 1:56 PMHappy to hear you have resolved it
m
Mike92988
11/10/2021, 1:56 PMbut I'm well aware you can do this all through the library and it would make my life way easier, but that's not how the guy i'm working for wants it done
Mike92988
11/10/2021, 1:56 PMand the customer is always right of course lol
s
silentworks
11/10/2021, 1:59 PMhehe
silentworks
11/10/2021, 2:00 PMJust note you are the developer, so if the customer isn't the developer working on the project, they should be taking your recommendation
m
Mike92988
11/10/2021, 2:01 PMYou are right x10000, thank you